OICR Cancer Stem Cell Program - Biostatistics Service

Biostatistics Service is freely available to all Cancer Stem Cell program members. You can get help with the design issues of microarray experiments, for example, sample size, biological replicates, or pooled samples, etc. This site contains information for biostatstics resource for OICR Cancer Stem Cell Program.

VLOOKUP used to compare 2 Excel spreadsheets: After the analysis of a microarray experiment, often you have few Excel spreadsheets and want to find out which genes are commons between the 2 spread sheets, etc. With large data sets, this seems a daunting task. Efficient use of Excel function VLOOKUP can help you find commons between the 2 spreadsheets. VLOOKUP function can also be used to pull information from one spreadsheet on the basis of some reference values from the other spreadsheet & concatenate the set of information with the 2nd spreadsheet. For detailed instructions, please download the vlookup_new.xlsx file below instead of viewing it in web browser.

CSCBiostatService (last edited 2014-06-20 13:42:20 by ChangjiangXu)

MoinMoin Appliance - Powered by TurnKey Linux