Kolmogorov-Smirnov Test in Excel using the QI Macros

When to Use the Kolmogorov-Smirnov Test

A Kolmogorov-Smirnov Test is a goodness of fit test.

Test Example

A psychiatric hospital has non-normal lengths of stay (column A-sorted).

Hypothesis Test Results: For each signficance level from 0.2 to 0.01, the template determines if one should reject or accept the hypothesis that the cumulative sample function matches the cumulative probability function.

Watch Non-parametric tests in Excel Video

The Kolmogorov-Smirnov Test 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