ANOVA calcs 1
Download: ANOVA_Calcs1_init.xlsx
Introduction
Variability Partitioning
In ANOVA observations belong to a group. In one-way ANOVA the grouping only goes one level deep; you can also have sub-groups and sub-sub-groups. The structure of the data is shown in the image below. You can imagine the data as a table in which the rows correspond to different groups and the columns correspond to different observations or measurements. So measurement refers to the measurement in the group.

ANOVA famously has a lot of equations (though they are represented more simply using matrix algebra). The sum-of-squares (SS) terms are all sums of squared deviations from a mean of some kind. They measure unscaled variability. Greater deviation from the mean leads to larger SS values but it is “unscaled” because they are additive and adding more groups and measurements will increase them even if the underlying sources of variability do not change. The is the key equation that partitions the variability into two sources: that due to changing group properties (between-group variability, ) and that due to measurement or observational uncertainty (within-group variability, ).
The equations below show how ANOVA can provide estimates of those two sources of variability. The estimate of is the pooled standard deviation; it assumes homogeneous variance meaning that it assumes all measurements share the same measurement variability. The estimate of is based on the difference between the and terms.
Significance Testing
Significance testing is based on a one-sided confidence “interval”: a lower confidence bound of a comparison statistic. That statistic is the ratio of the between-group and within-group mean square values.
If there is no between-group variability (ie, if ) then this statistic is estimating the ratio of two independent estimates of the same quantity, , and should be statistically indistinguishable from 1. The usual practice is to calculate a lower confidence bound; if that boundary is larger than 1 then there is confidence that the comparison statistic is significantly greater than 1. (The reason this is a one-tailed test is because since variances cannot be negative.)
Learning Goals
- Develop an intuitive grasp of the ANOVA equations that partition variability between its sources
- Learn how to do ANOVA calculations in Excel
- Be able to interpret the output of ANOVA calculations
Tasks
- Review the ANOVA data structure
- Review the ANOVA equations, defining terms
- Perform ANOVA calculations using
ANOVA1SandANOVA - Interpret each item in the ANOVA table output
When finished your spreadsheet should look something like the image below.
