Emilysimso Week 14

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
  • Column 1 = ID
  • Column 2 = MasterIndex (has numbers 1-10819)
• Sheet 1 was labeled Compiled Raw Data
  • Took the log data from the 1, 5, 20, and 60 time points - had 16 total data columns (four for each time point)
• Created MasterSheet in sheet 2
  • Deleted 704 rows after alphabetizing data A-Z according to the ID number because they were controls (started with Blank, blank, gDNA, NC-, or ORF)
  • 1333 cells have the error #NUM!
    • Replaced these with nothing so that the cells are blank
• 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)

Files

• File:CompiledRawData 20151201 HMH.xlsx