Kevinmcgee Week 8

Digital Notebook

1. Downloaded the Stanford Microarray Database data.
2. 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.
3. Made column for each called scaled_centered which subtracts average and divides by standard deviation ( =(B4-B$2)/B$3 ).
4. 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) ).
5. 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

• File:Merrell Compiled Raw Data Vibrio KevinMcGee 10132013.xls