# Kruskal-Wallis Test in Excel

## When to Use the Kruskal-Wallis Test

A Kruskal-Wallis test is like an Analysis of Variance (ANOVA). It is a non-parametric test that compares unmatched groups. Samples must be random, independent and five or more per sample.

**Note: **Excel does not do statistical tests of non-normal (i.e., not "bell shaped") data. QI Macros, adds this functionality with a set of of non-parametric statistical test templates.

### Kruskal-Wallis Example

A golfer wants to compare three drivers to determine which one is the longest. He hits five drives with each driver and measures the distance.

To conduct a test using QI Macros he will:

- Click on the QI Macros menu > Stat Templates to open the non-parametric test template. Then select the "Kruskal-Wallis" tab.
- Input the data into the yellow shaded cells in columns A:I.
- QI Macros will perform the calculations in columns J:R and display the results in columns S:AA. In the example, below we have hidden the unused columns. (Note never delete rows or columns in QI Macros templates as you may accidentally break formulas.)

**Interpreting the Hypothesis Test results**: Since p (0.151) is greater than alpha (0.05), he **cannot** reject the null hypothesis (accept the null hypothesis) that the distance of all three drivers is the same. If p was less than alpha, he would reject the null hypothesis.

*Default Significance Level is 0.05*

* H*: This is the test statistic that helps you determine whether the medians of two (or more) groups are different, in combination with your p value.

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