Non-Parametric Tests in Excel

Use 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. QI Macros, however, have a set of templates to handle non-parametric data.

  Samples
Variable (Continuous)

Data

1
2
3
Independent   Wilcoxon

Mann-Whitney

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  

Learn More

Hypothesis Testing Quick Reference Card

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!