Excel function to do a t-test

I did the following in Excel.  Row 3 contained results for the treatment group.  Row 4 had results for the comparison group.  F columns had group averages.  J columns had standard errors.

Statistical test
Column N

Average score difference

Column O

Pooled standard error

T-value (absolute value) If t-value greater than 1.96 (alpha=5%)
=F4-F3 =SQRT( ( (J3*J3) / G3 ) + ( (J4*J4 ) / G4 ) ) =ABS(N3/O3)  *

Leave a Reply