Need One-Way ANOVA Post Hoc Tests in Excel?

QI Macros Does It For You!

Create One-Way ANOVA using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Statistical Tools > ANOVA > ANOVA One-Way
  3. QI Macros will do the math and analysis for you.

After a one-way ANOVA finds a significant difference in means, Post Hoc testing helps identify which of the differences are significant.

Post Hoc Tests  

Post Hoc tests compare the differences between the means with various factors to identify significant differences. There are a number of ways that these factors are determined, but LSD, HSD and Scheffe's are three of the more common ones:

  • LSD - Fisher's Least Significant Difference
  • HSD - Tukey's Honestly Significant Difference reduces Type 1 error.
  • Scheffe's is the most conservative of the three
 

Note: Excel does not do post hoc tests; QI Macros adds this functionality.

Example Using QI Macros Add-in and Data From Montgomery's Intro to SPC book

Using the tensile strength data in columns A to F, QI Macros calculations are shown in columns G to P. The Post Hoc tests are in cells M2:P8.

Post Hoc test output

Interpretation of Results

Since the p-value is less than 0.05, the Means are considered Different. If the mean difference is greater than LSD, HSD or Scheffe's, the difference is considered significant.

Since Scheffe > HSD > LSD, QI Macros identifies significant differences by shading the results as follows:

  • greater than Scheffe's it is shown in red
  • less than Scheffe but greater than HSD it is shown in rose
  • less than HSD but greater than LSD, it is shown in yellow
  • less than LSD, no shading

In the example below the difference between these tensile strengths is:

  • greater than Scheffe (5.797) so they are shaded in red: 5% and 15%, 5% and 20%
  • less than Scheffe (5.797) but greater than HSD (4.122) so they are shaded in rose: 5% and 10%, 10% and 20%, 15% and 20%
  • less than HSD (4.122) but greater than LSD (3.072) so they are shaded in yellow: none
  • less than LSD (3.072) so they are not shaded at all: 10% and 15%

Test results

What's Cool About QI Macros One-Way ANOVA Post Hoc Tests? 

Unlike other statistical software, QI Macros is the only SPC software that compares the p-value (0.000) to the significance (0.05) and tells you to "Reject the Null Hypothesis because p<0.05" and that the "Means are Different/Means are not the Same".

Then the Post Hoc tests tell you which differences are significant.

Stop Struggling with Post Hoc Tests!
Start creating your Post Hoc Tests in just minutes.

Download a free 30-day trial. Get Post Hoc Tests now!


Why Choose QI Macros Statistical Software for Excel?

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets p-values for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free

affordable

Affordable

  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support