NonParametric Tests in Excel
Use 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. QI Macros, however, have a set of templates to handle nonparametric data.
Samples  
Variable (Continuous) Data  1  2  3 
Independent  Wilcoxon  
Dependent  Spearman  
Goodness of Fit  KolmogorovSmirnov (KS)  Tukey  
Attribute (Ordinal Data  
Independent  1Sample Sign Test  Sign Test  
Dependent  Spearman 
NonNormal vs Normal Tests 

Nonparametric  Parametric (Normal) 
1sample sign  1sample ztest 1sample ttest 
Sign Test  Paired twosample t Test 
Wilcoxon Signed Rank Test  
MannWhitney Wilcoxon Rank Sum Test 
2sample ttest 
KruskalWallis  oneway ANOVA 
Mood's Median  oneway ANOVA 
Friedman  2way ANOVA test 