Difference between revisions of "Kevinmcgee Week 8"
From LMU BioDB 2013
Kevinmcgee (Talk | contribs) |
Kevinmcgee (Talk | contribs) (Updated file names) |
||
| Line 7: | Line 7: | ||
| − | *[[ | + | *[[Media: Merrell_Compiled_Raw_Data_Vibrio_KevinMcGee_10132013.txt|.txt spreadsheet]] |
| − | *[[ | + | *[[Media: Merrell_Compiled_Raw_Data_Vibrio_KevinMcGee_10132013.xls|.xls spreadsheet]] |
Revision as of 16:31, 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).
