Scheffe Test (Post Hoc Test) after ANOVA in Excel

This video demonstrates how to conduct a Scheffe test (post hoc test) after a one-way ANOVA using Microsoft Excel. The Scheffe test is a conservative post hoc test (controls Type I Error rate). In this example, three groups are compared using a one-way AVOVA using the Data Analysis tools in Excel. In these tools, the one-way ANOVA is referred to as “ANOVA: Single Factor.” The results of this ANOVA are interpreted. The formula to calculate the Scheffe test is constructed using the “mean square within,” the sample sizes, and the means. The statistic is calculated for every pairwise comparison and compared to the critical value for the Scheffe test, which is calculated from the F critical value. A statistically significant result occurs when the statistic exceeds the F critical value.