Difference between revisions of "Kevinmcgee Week 8"
From LMU BioDB 2013
Kevinmcgee (Talk | contribs) (Updated file names) |
Kevinmcgee (Talk | contribs) |
||
| Line 10: | Line 10: | ||
*[[Media: Merrell_Compiled_Raw_Data_Vibrio_KevinMcGee_10132013.xls|.xls spreadsheet]] | *[[Media: Merrell_Compiled_Raw_Data_Vibrio_KevinMcGee_10132013.xls|.xls spreadsheet]] | ||
| + | |||
| + | *[[Media: Increased_KevinMcGee-Criterion0-GO.txt]] | ||
| + | |||
| + | *[[Media: Merrell_Compiled_Raw_Data_Vibrio_Dillon_Williams.EX.txt]] | ||
| + | |||
| + | *[[Media: Merrell_Compiled_Raw_Data_Vibrio_Dillon_Williams.gmf]] | ||
| + | |||
| + | *[[Media: Increased_KevinMcGee-Criterion0-GO.xls]] | ||
| + | |||
| + | *[[Media: Merrell_Compiled_Raw_Data_Vibrio_Dillon_Williams.gex]] | ||
Revision as of 17:59, 15 October 2013
Digital Notebook
- Downloaded the Stanford Microarray Database data.
- Made a new page called scaled_centered. Copied data from previous page, and calculated average ( =AVERAGE(B4:B5224) ) and standard deviation ( =STDEV(B4:B5224) )of them.
- Made column for each called scaled_centered which subtracts average and divides by standard deviation ( =(B4-B$2)/B$3 ).
- Made a new sheet called statistics. Copied data from previous page and took the average log fold change for each id value(=AVERAGE(B2:E2)). We then made a Tstat column which tells us if the scaled or centered average log ratio has change ( =AVERAGE(N2:P2)/(STDEV(N2:P2)/SQRT(3) ) ). Finally, made a column for Pvalue ( =TDIST(ABS(R2),2,2) ).
- Made page called forGenMAPP. On this page, pasted statistics page, then prepared for GenMAPP (number of decimal places, location of some column of information).
