Difference between revisions of "Kmeilak Week 8"
From LMU BioDB 2013
(Created page with "==Overview of Microarray Data Analysis== Electronic Lab Notebook *Downloaded Merrill Compiled Raw Data file from [http://www.openwetware.org/wiki/BIOL398-01/S10:Sample_Micro...") |
(→Overview of Microarray Data Analysis) |
||
| Line 8: | Line 8: | ||
*Copied all data from compiled_raw_data worksheet into scaled_centered worksheet | *Copied all data from compiled_raw_data worksheet into scaled_centered worksheet | ||
*Inserted two rows underneath header row (ID, A1, etc) | *Inserted two rows underneath header row (ID, A1, etc) | ||
| − | *Calculated average and standard deviation for each | + | *Calculated average and standard deviation for each column (i.e. =AVERAGE(B4:B5224); =STDEV(B4:B5224)) by typing function into appropriate labeled row and copying and pasting formulas across all columns. |
Revision as of 17:14, 10 October 2013
Overview of Microarray Data Analysis
Electronic Lab Notebook
- Downloaded Merrill Compiled Raw Data file from Sample Microarray Analysis for Vibrio cholerae page
- Saved as Merrell_Compiled_Raw_Data_Vibrio_KM_20131010.xls
- Opened file in excel; created second worksheet and named it scaled_centered
- Copied all data from compiled_raw_data worksheet into scaled_centered worksheet
- Inserted two rows underneath header row (ID, A1, etc)
- Calculated average and standard deviation for each column (i.e. =AVERAGE(B4:B5224); =STDEV(B4:B5224)) by typing function into appropriate labeled row and copying and pasting formulas across all columns.
