Looking for NonParametric Tests in Excel?
Excel does not have them but QI Macros addin does!
Use QI Macros ReadyMade Templates for nonparametric 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 nonnormal (i.e., not "bell shaped") data. However, QI Macros, has a set of easytouse Excel templates to handle nonparametric data.
List of the NonParametric Tests in QI Macros
Samples  
Variable (Continuous) Data  1  2  3 
Independent  
Dependent  Spearman  
Goodness of Fit  KolmogorovSmirnov (KS)  Tukey  
Attribute (Ordinal Data  
Independent  1Sample Sign Test  Sign Test  
Dependent  Spearman 
QI Macros Contains Statistical Tests for Normal Data Too
NonNormal vs Normal Tests 

Nonparametric  Parametric (Normal) 
1Sample Sign  1Sample zTest 1Sample tTest 
Sign Test  Paired TwoSample tTest 
Wilcoxon Signed Rank Test  
MannWhitney Wilcoxon Rank Sum Test 
2Sample tTest 
KruskalWallis  oneway ANOVA 
Mood's Median Test  oneway ANOVA 
Friedman  2way ANOVA Test 
Haven't you waited long enough?
Start running Nonparametric tests in just minutes.
Download a free 30day trial. Run Nonparametric tests on your data now!
Nonparametric tests are one of many statistical tests included in QI Macros addin 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.