Ryan N. Willhite Week 12: Difference between revisions
From OpenWetWare
Jump to navigationJump to search
Line 8: | Line 8: | ||
# Insert columns and input equation | # Insert columns and input equation | ||
* (cell 4-average)/Stdev) | * (cell 4-average)/Stdev) | ||
* Scaling and centering | |||
**=(B4-$B$2)/$B$3 | |||
*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 | |||
===Perform Statistical Analysis=== | ===Perform Statistical Analysis=== | ||
[[Image:Rnwwork413.xls]] | [[Image:Rnwwork413.xls]] |
Revision as of 09:14, 19 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
- 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