Emilysimso Week 14
From LMU BioDB 2015
Revision as of 00:49, 2 December 2015 by Emilysimso (Talk | contribs) (→Procedure: Added notes on scaling and centering)
Goal
- GenMAPP Users should complete the statistical analysis of the microarray data, import the data into GenMAPP, and run MAPPFinder.
Procedure
- Created a new CompiledRawData spreadsheet
- Sheet one was labeled Compiled Raw Data
- Took the log data from the 1, 5, 20, and 60 time points
- Created MasterSheet in sheet 2
- Created ScalingCentering in sheet 3
- Copied over data from MasterSheet
- Added two extra rows on top of data for Average and Standard Deviation
- Some of the columns had divided by zero errors for the average and standard deviation
- Had to delete #DIV/0! that came up for some of the genes in these columns
- Made the cells that contained this error blank by searching for "DIV" and using the replace function to make this blank
- C1_rep2 - 2 replacements
- C5_rep4 - 1 replacement
- C20_rep2 - 2 replacements
- C20_rep3 - 1 replacement
- C20_rep4 - 1 replacement
- C60_rep1 - 2 replacements
- C60_rep2 - 1 replacement
- For the scaled and centered columns in the ScalingCentering tab - used the equation =(C4-C$2)/C$3 (for the first column)
Notes
- Deleted 704 rows after alphabetizing data A-Z
- 1333 cells have the error #NUM!
- Replaced these with nothing
