The one-way ANOVA procedure organizes all its calculations into a structured ANOVA table. This table decomposes the total variation in the data into between-group and within-group components, then uses their ratio to test whether the group means differ.
SST measures the total variation in the dataset — how much all individual observations deviate from the grand mean (grand). It is the starting point: everything we observe in the data is captured by SST.
=DEVSQ(all_data)xij is each observation and grand is the grand mean of all observations.
SSB measures how much the group means differ from the grand mean. If all group means were identical, SSB would be zero. Large SSB suggests the groups have genuinely different population means.
Use Data Analysis Toolpak > ANOVA: Single Factornj is the sample size in group j, j is group j's mean, and grand is the overall grand mean.
SSW (also called SSE, Sum of Squares Error) measures variation within each group. It captures the natural randomness — individual differences that exist even among members of the same group. SSW = SST − SSB.
SSW = SST − SSB (from Toolpak output)To make SSB and SSW comparable, we divide each by their respective degrees of freedom to obtain mean squares. The ratio of MSB to MSW gives the F-statistic.
=F.TEST(range1, range2) or use Data Analysis Toolpakk is the number of groups and N is the total number of observations. MSB = SSB/(k−1), MSW = SSW/(N−k).
The F-statistic follows an F-distribution, which is always right-skewed and only takes positive values. Unlike the t-test, the ANOVA F-test is always right-tailed — we reject H0 only when the F-statistic is unusually large, indicating that between-group variation greatly exceeds within-group variation.
Compare the computed F to the critical value from the F-distribution table (or compute a p-value):
The ANOVA result tells NorthStar's HR team that employee satisfaction is not equal across all four divisions. However, it does not reveal which divisions differ. Corporate Services (mean 78) appears highest and Manufacturing (mean 65) lowest, but post-hoc tests (Chapter 3) are needed to confirm which specific pairwise differences are statistically significant.
→ Use the Tukey Q Calculator to find the critical value for your post-hoc comparisons.
The F-statistic is the ratio of between-group mean square to within-group mean square. A large F means the group means are more spread out than you would expect from random variation alone. The F-test is always right-tailed: only large F values lead to rejection. Always report F, degrees of freedom, and the p-value together.
This chapter walked through the mechanics of one-way ANOVA, from constructing the ANOVA table to making a decision with the F-test.
ANOVA Table: Decomposes total variation (SST) into between-group (SSB) and within-group (SSW) components. Mean squares are obtained by dividing by degrees of freedom.
F-Statistic: F = MSB / MSW. Large values indicate group means differ more than expected by chance.
Decision: Compare F to the critical value or use the p-value. Reject H0 when F exceeds the critical value.