# Need One-Way ANOVA Post Hoc Tests in Excel?

## QI Macros Does It For You!

### Create One-Way ANOVA using QI Macros:

- Select your data.
- Click on QI Macros menu > Statistical Tools > ANOVA > ANOVA One-Way
- 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.

### 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%

### 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

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

### Proven and Trusted

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

### Affordable

- Only
**$349 USD**

Quantity Discounts Available - No annual fees
- Free Technical Support