Difference between revisions of "Kevinmcgee Week 8"
From LMU BioDB 2013
Kevinmcgee (Talk | contribs) (Created page with "Digital Notebook #Downloaded the Stanford Microarray Database data. #Made a new page called scaled_centered. Copied data from previous page, and calculated average ( =AVERAGE(...") |
Kevinmcgee (Talk | contribs) (Added digital notebook and txt file) |
||
| Line 5: | Line 5: | ||
#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 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). | #Made page called forGenMAPP. On this page, pasted statistics page, then prepared for GenMAPP (number of decimal places, location of some column of information). | ||
| + | |||
| + | |||
| + | [[File: Merrell_Compiled_Raw_Data_Vibrio_KevinMcGee_10132013.txt]] | ||
Revision as of 21:01, 13 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).
File:Merrell Compiled Raw Data Vibrio KevinMcGee 10132013.txt
