Emilysimso Week 14
From LMU BioDB 2015
Revision as of 04:33, 3 December 2015 by Emilysimso (Talk | contribs) (→Procedure: added averages details)
Contents
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)
- Had to run the data through a script to get rid of duplicates
- Calculated the averages for the technical replicates for each of the time points
- Created a new tab labeled Statistics
- Copied the technical averages into this tab
- Calculated the biological averages for each time point
- Calculated the Average Log Ratios by subtracting the value for C0 from each of the C points and subtracting C60 from each of the F points
Files
Weekly Assignment Information
Assignments
- Week 1
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 7
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12
- Week 13
- Week 14
- Week 15
Individual Journal Entries
- Emilysimso Week 2
- Emilysimso Week 3
- Emilysimso Week 4
- Emilysimso Week 5
- Emilysimso Week 6
- Emilysimso Week 7
- Emilysimso Week 8
- Emilysimso Week 9
- Emilysimso Week 10
- Emilysimso Week 11
- Emilysimso Week 12
- Emilysimso Week 13
- Emilysimso Week 14
- Emilysimso Week 15
Class Journal Entries
- Class Journal Week 1
- Class Journal Week 2
- Class Journal Week 3
- Class Journal Week 4
- Class Journal Week 5
- Class Journal Week 6
- Class Journal Week 7
- Class Journal Week 8
- Class Journal Week 9
- Class Journal Week 10
- Class Journal Week 11
- Class Journal Week 12
- Class Journal Week 13
- Class Journal Week 14
- Class Journal Week 15
