Kruskal-Wallis Test in Excel using the QI Macros

When to Use the Kruskal-Wallis Test

A Kruskal-Wallis test is like an analysis of variance (ANOVA) test. Samples must be random, independent and five or more per sample. Consider the following example.

Test 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. Entering the data into columns A:C, he gets:

Hypothesis Test: Since p (0.151) is greater than alpha (0.05) accept the null hypothesis that the distance of all three drivers is the same.

Watch Non-parametric tests in Excel Video

The Kruskal-Wallis test is just one of the tests included in the QI Macros Statistical Process Control software. Other tests include:

• Overvew of all hypothesis tests in Excel
• Other Non-parametric tests in Excel in the QI Macros

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma