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.

Variable (Continuous) Data

1 2 3


Wilcoxon Rank Sum

Mood's Median Test


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?

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets p-values for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

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



  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support