Analysis of Variance (ANOVA)
When to Use ANOVA? When You Want to Determine if the Means (i.e., Averages) Are the Same or Different
Analysis of variance (ANOVA) can help you determine if two or more samples have the same "mean" or average. This is a form of "hypothesis testing."
The null hypothesis is that the means are equal:
- H0: Mean1 = Mean2
The alternate hypothesis is that the means are not equal:
- Ha: Mean1 <> Mean2
The goal is to accept or reject the null hypothesis (i.e., the samples have different means) at a certain confidence level (95% or 99%).
What's cool about QI Macros ANOVA? When you run ANOVA, you don't have to think. QI Macros automatically compare the p-value to the signficance and tell you if you should accept or reject the hypothesis and if the means are the same or different.
Excel and the QI Macros can perform:
- One-Way, Single Factor ANOVA
- Example (click here)
- Two-Factor ANOVA - without replication
- Example (click here)
- Two-Factor ANOVA Example - with replication
- Example (click here)
ANOVA Assumptions
ANOVA assumes three things:
- The data is randomly selected.
- The data is normally distributed.
- The populations have equal variances.








