sum of d.f. mean Fs squares square between 0.00452 4 0.001113 7.12 groups within 0.00539 34 0.000159 groups total 0.00991 38 Using the AMD data, calculate the p value: =F.DIST.RT (x, d.f.1, d.f.2) If you're not going to use the mean squares for anything, you could just report this as "The means were significantly heterogeneous (one-way anova, F4, 34=7.12, P=2.8×10-4)." The degrees of freedom are given as a subscript to F, with the numerator first. Decision Rule If the decision is to reject the null, then at least one of the means is different. However, the anova does not tell you where the difference lies. For this, you need another test, either the Scheffe' or Tukey-Kramer test. Tukeys or Sheffe’s post-hoc analysis Online app and Tukey’s and Tukey’s significant/probability table What did you find? I found that four of the combinations were significant at 0.05. Which four? Good news (finally): Excel include an "Analysis Toolpak," which includes an "Anova: Single Factor" function that will do a one-way anova. It does not include any techniques for unplanned comparisons of means, and it does not partition the variance. Try it now. On your own:
sum of squares d.f. mean square Fs between groups 0.00452 4 0.001113 7.12 within groups 0.00539 34 0.000159 total 0.00991 38 Using the AMD data, calculate the p value: =F.DIST.RT (x, d.f.1, d.f.2) If you're not going to use the mean squares for anything, you could just report this as "The means were significantly heterogeneous (one-way anova, F4, 34=7.12, P=2.8×10-4)." The degrees of freedom are given as a subscript to F, with the numerator first. Decision Rule If the decision is to reject the null, then at least one of the means is different. However, the anova does not tell you where the difference lies. For this, you need another test, either the Scheffe' or Tukey-Kramer test. Tukeys or Sheffe’s post-hoc analysis Online app and Tukey’s and Tukey’s significant/probability table What did you find? I found that four of the combinations were significant at 0.05. Which four? Good news (finally): Excel include an "Analysis Toolpak," which includes an "Anova: Single Factor" function that will do a one-way anova. It does not include any techniques for unplanned comparisons of means, and it does not partition the variance. Try it now. On your own:
one_way_anova_Student_Engagement_Tasks.docx