Ryan N. Willhite Week 12

From OpenWetWare

Revision as of 11:38, 20 April 2010 by Ryan N. Willhite (Talk | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

Contents

Work day

Normalize Ratios

  1. Add rows
  2. Type Equations
  • =AVERAGE( : )
  • =STDEV( : )
  1. Insert columns and input equation
  • (cell 4-average)/Stdev)
  • Scaling and centering
    • =(B4-$B$2)/$B$3

Image:Rnwxcl1.JPG

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


Image:Rnwxcl2.jpeg

Sanity Check: Number of genes significantly changed

Image:Rnwwork413.xls

Personal tools