Difference between revisions of "Emilysimso Week 14"

Revision as of 00:49, 2 December 2015

GenMAPP Users should complete the statistical analysis of the microarray data, import the data into GenMAPP, and run MAPPFinder.

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)

@@ Line 10: / Line 10: @@
 **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==