Looking for a Kolmogorov-Smirnov Test in Excel?

QI Macros has a ready made Kolmogorov-Smirnov (KS) template for you!

Kolmogorov-Smirnov is a Goodness of Fit Test

The Kolmogorov-Smirnov template is one of the many non-parametric statistical tests performed by QI Macros Add-in for Excel.

Kolmogorov-Smirnov template output

Kolmogorov-Smirnov Example using QI Macros KS Template

A psychiatric hospital has non-normal lengths of stay (column A-sorted). To conduct a test using QI Macros:

  1. Click on the QI Macros menu > Stat Templates > Kolmogorov-Smirnov to open the non-parametric test template. Then click on the K-S tab.
  2. Input your data into the yellow shaded cells in column A.
  3. Sort the data in column A in ascending order (smallest to largest.) Excel will prompt you to expand your selection but choose continue with the current selection.

    sort warning prompt in Excel
  4. QI Macros will perform the calculations and interpret the results for you:
  5. Kolmogorov-Smirnov template output

Interpreting the KS Test Results

For each significance level from 0.2 to 0.01, QI Macros template tells you (in column H) if you should reject the null hypothesis or cannot reject the null hypothesis that the cumulative sample function matches the cumulative probability function.

Note: Excel doesn't have the ability to do statistical tests of non-normal (i.e., not "bell shaped") data. QI Macros adds this functionality with a set of templates to handle non-parametric data.


Haven't you waited long enough?
Start running Kolmogorov-Smirnov tests in just minutes.

Download a free 30-day trial. Run Kolmogorov-Smirnov tests on your data now!

Kolmogorov-Smirnov tests are one of many statistical tests included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. You will find the statistical tools and templates on the far left side of QI Macros menu.

statistical tests in QI Macros Excel add-in

QI Macros draws these SPC charts as well