# Ryan N. Willhite Week 12

### From OpenWetWare

## Contents |

## 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