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 | |||
| Dependent | Spearman | ||
| Goodness of Fit | Kolmogorov-Smirnov (K-S) | Tukey | |
| Attribute (Ordinal Data | |||
| Independent | 1-Sample Sign Test | Sign Test | |
| Dependent | Spearman | ||
Non-Normal vs Normal Tests |
|
| Non-parametric | Parametric (Normal) |
| 1-Sample Sign | 1-Sample z-Test 1-Sample t-Test |
| Sign Test | Paired Two-Sample t-Test |
| Wilcoxon Signed Rank Test | |
| Mann-Whitney Wilcoxon Rank Sum Test |
2-Sample t-Test |
| Kruskal-Wallis | one-way ANOVA |
| Mood's Median Test | one-way ANOVA |
| Friedman | 2-way ANOVA Test |
Learn More
Why Choose QI Macros Statistical Software for Excel?
Easy to Use
- Works Right in Excel
- Interprets p-values for You
- Accurate No-Worry Results
- Free Training Anytime
Proven and Trusted
- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free
Affordable
- Only $349 USD
Quantity Discounts Available - No annual fees
- Free Technical Support
