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:

ANOVA Assumptions

ANOVA assumes three things:

  • The data is randomly selected.
  • The data is normally distributed.
  • The populations have equal variances.
Purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!
How We Can Help Download Free QI Macros Trial Buy QI Macros for Excel Now