Procedure taken from [http://www.openwetware.org/wiki/BIOL398-01/S10:Sample_Microarray_Analysis_Vibrio_cholerae]. Reworded to reflect what I did.
+
Procedure taken from [http://www.openwetware.org/wiki/BIOL398-01/S10:Sample_Microarray_Analysis_Vibrio_cholerae BIOL398-01:Sample_Microarray_Analysis_Vibrio_cholerae]. Reworded to reflect what I did.
I scaled and centered the data (between chip normalization) by performing the following operations:
I scaled and centered the data (between chip normalization) by performing the following operations:
In cell N4, I typed the following equation:
In cell N4, I typed the following equation:
=(B4-B$2)/B$3
=(B4-B$2)/B$3
−
We wanted the data in cell B4 to have the average subtracted from it (cell B2) and be divided by the standard deviation (cell B3). The dollar signs make sure that the proper cells are always used.
+
We wanted the data in cell B4 to have the average subtracted from it (cell B2) and be divided by the standard deviation (cell B3). Why is this imporant? The dollar signs make sure that the proper cells are always used, the values are always taken from B2 and B3 instead of incrementing.
I then copied and pasted this equation into the entire column across all rows.
I then copied and pasted this equation into the entire column across all rows.