Looking for Non-Parametric Tests in Excel?

Excel does not have them but QI Macros add-in does!

Use QI Macros Ready-Made Templates for non-parametric tests when data is:

  • Counts or frequencies of different types
  • Measured on nominal or ordinal scale
  • Not meeting assumptions of a normal test
  • Distribution is unknown
  • A small sample
  • Imprecise
  • Skewed data that make the median more representative
 
Note: Excel doesn't have the ability to do statistical tests of non-normal (i.e., not "bell shaped") data. However, QI Macros, has a set of easy-to-use Excel templates to handle non-parametric data.

List of the Non-Parametric Tests in QI Macros

  Samples
Variable (Continuous) Data

1 2 3
Independent  

Wilcoxon

Mann-Whitney
Wilcoxon Rank Sum

Mood's Median Test

Kruskal-Wallis
Friedman

Dependent   Spearman  
Goodness of Fit Kolmogorov-Smirnov (K-S) Tukey  
Attribute (Ordinal Data

     
Independent 1-Sample Sign Test Sign Test  
Dependent   Spearman  

QI Macros Contains Statistical Tests for Normal Data Too

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

Download a free 30-day trial. Run Non-parametric tests on your data now!

Non-parametric 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