ANOVA and Post-Hoc Analysis Workbook Template (Excel)
This Excel workbook checks whether the averages of several groups really differ, and which groups differ. It has these sheets: One-Way ANOVA: 2–6 groups. Gives the summary statistics, the ANOVA table, an equal-variance check (Levene’s test), Welch’s ANOVA for when variances differ, effect sizes, a chart and a written conclusion. Post-Hoc Tests: compares every pair of groups using Tukey, Games-Howell and Bonferroni, and says which method to use. Two-Way ANOVA: two factors and how they interact, with an interaction chart. From Summary Stats: runs an ANOVA when you only have each group’s size, mean and standard deviation. q Table: the critical-value table that Tukey and Games-Howell use. How to use: Type over the blue sample data with your own. On the One-Way sheet, group names go in row 7 and values in columns A–F. On the Two-Way sheet, enter one observation per row. Pick α (0.10, 0.05 or 0.01) in the yellow cell and name your outcome variable. Look at Levene’s test first. If its p-value is below α, report Welch’s F and use Games-Howell. Read the yellow key cells (F, p-value, η²) and the written conclusion. The Decision cell turns green when the result is significant. If the ANOVA is significant, open Post-Hoc Tests and report the pairs marked “Yes” with their confidence intervals. On the Two-Way sheet, type the level names in the blue grid cells exactly as they appear in your data. If the interaction is significant, interpret the cell means rather than the main effects alone. To reuse the workbook, delete only the blue data. Unused groups and levels stay blank.