In: Statistics and Probability
5. [Using both Excel (show your work) and SPSS]
Perform three post hoc tests, comparing the three pairs of means from the previous question. Are there significant differences between:
A. Baseline and one minute?
B. Baseline and two minutes?
C. One minute and two minutes?
Use a = .05 / 3 = .017 for each test.
i only need excel version no need for Spss. Thank you
Step-1: perform one-way ANOVA
step-2: obtain least significant difference by using the given formula
LSD=t(α,error df)*sqrt(2*EMS/r)
Step-3: obtain the pairwise mean differences and compare with LSD
S stands for significant and NS stands for non-significant
Final Answer:
A. Baseline and one minute- Significant difference
B. Baseline and two minutes- Non significant difference
C. One minute and two minutes- Significant difference