For all of you who are having trouble with the t-Test, Mr. O, Sinn and I created step-by-step instructions on how to perform the test during lunch. You know you love us.
Calculate the first average (x1) (in Excel; =Average)
Calculate the second average (x2)
Subtract the means (x1 – x2)
Count the number of entries in each data set.
n1 = number in first data set
n2 = number in second data set
Plug these into the formula
Calculate s (use calculator) or Excel (=StDeva)
Plug-n-chug to find t
Calculate Degrees of Freedom:
d.f. = (n1 + n2 – 2)
Only use the line in the table that corresponds with your d.f.
Use p = or
Compare t values (yours and the one you found in the table). If your t value is greater than the one listed, then reject the null-hypothesis and accept the alternative hypothesis.