How to normalize data?
Data normalization means transforming the data in such a way that the mean = 0 and the variance = 1. You may transform your data in the active worksheet in two ways. Click Data|Standardize values in rows will transform your data so that values in each row will have mean = 0 and variance = 1. Click Data|Standardize values in columns will transform your data so that values in each column will have mean = 0 and variance = 1. You may use the Average and Stdev function to verify the transformation if you are very cautious. The use of these two functions are the same as in EXCEL, i.e., =average(b2:b9), = Stdev(b2:b9). • How to do an integrated analysis of microarray data? Here is brief tutorial. Open a file (either an EXCEL file or a tab-delimited, or comma-delimited file) that contains your microarray data. It might be a good idea to start with the sample data file (yeast200.xls) included in the AMADA distribution. The 200 means that it includes only the first 200 loci. It should be found i