Difference between revisions of "Kmeilak Week 8"
From LMU BioDB 2013
(→Overview of Microarray Data Analysis) |
(→Overview of Microarray Data Analysis) |
||
| Line 9: | Line 9: | ||
*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 column (i.e. =AVERAGE(B4:B5224); =STDEV(B4:B5224)) by typing function into appropriate labeled row and copying and pasting formulas across all columns. | *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. | ||
| + | |||
| + | ==Files== | ||
| + | |||
| + | [[Media:Merrell_Compiled_Raw_Data_Vibrio_KM_20131010.xls]] | ||
| + | [[ | ||
Revision as of 17:29, 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.
