#acl CancerStemCellGroup:read,write == 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. '''Experiments Design''' * We provide help with design issues of microarrays experiments. To help you with better ideas of statistical planning of your experiment, we need clear and concise information about your plans. [[CancerStemCellProject/ChangjiangXu/BiostatService/Consulting| CONSULTING]] provides a document related to the type of information that we need to understand your experiment, if you are planning for a microarray experiment. * If you have data from microarrays experiment, we need certain information to understand and do efficient analysis of your data which are documented in [[CancerStemCellProject/ChangjiangXu/BiostatService/DataRequirements|DATA REQUIREMENTS]]. * For information regarding what you should expect from the service, please read [[CancerStemCellProject/ChangjiangXu/BiostatService/Expectations|EXPECTATIONS]]. '''Statistical Analysis''' * We also provide statistical analysis support for your lab experiments, for example, linear model fitting under different designs or sample size calculation, etc. '''Data Interpretation''' * If you need help with data interpretation (Pathway and Network Analysis), you can contact Dr. Veronique Voisin (Ph.D, bioinformatician) at veronique.voisin@gmail.com. * '''VLOOKUP''': 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 [[attachment:vlookup_new.xlsx| the vlookup_new.xlsx]] file instead of viewing it in web browser.