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


Why Choose QI Macros Statistical Software for Excel?

affordable

Affordable

  • Only $299 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets Results for You
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free