Ryan N. Willhite Week 12: Difference between revisions
From OpenWetWare
Jump to navigationJump to search
add screenshot |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
* [[Media:Saureus_import_all.txt | ''S. aureus data ready for import into GenMAPP'']] | |||
==Work day== | ==Work day== | ||
| Line 11: | Line 13: | ||
**=(B4-$B$2)/$B$3 | **=(B4-$B$2)/$B$3 | ||
[[Image:Rnwxcl1.JPG]] | |||
===Perform Statistical Analysis on the ratios=== | |||
| Line 24: | Line 29: | ||
TDIST(ABSCR2), (degrees of freedom, 2) | TDIST(ABSCR2), (degrees of freedom, 2) | ||
** degree of freedom= #of replicates-1 | ** degree of freedom= #of replicates-1 | ||
[[Image:Rnwxcl2.jpeg]] | |||
===Sanity Check: Number of genes significantly changed=== | |||
[[Image:Rnwwork413.xls]] | [[Image:Rnwwork413.xls]] | ||
Latest revision as of 15:38, 20 April 2010
Work day
Normalize Ratios
- Add rows
- Type Equations
- =AVERAGE( : )
- =STDEV( : )
- Insert columns and input equation
- (cell 4-average)/Stdev)
- Scaling and centering
- =(B4-$B$2)/$B$3
Perform Statistical Analysis on the ratios
- Average log fold change for replicates
- =AVERAGE(B2:E2)
- Make columns "Avg_LogFC_all"
- New column "Tstat"- T statistic
=AVERAGE (N2:P2)/ STDEV (N2:P2)/SQRT (#of replicates)
- New column "Pvalue."
TDIST(ABSCR2), (degrees of freedom, 2)
- degree of freedom= #of replicates-1
