Looking for Non-Parametric Tests in Excel?
Excel does not have them but QI Macros add-in does!
Use QI Macros Ready-Made Templates for 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. However, QI Macros, has a set of easy-to-use Excel templates to handle non-parametric data.
List of the Non-Parametric Tests in QI Macros
| 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 | ||
QI Macros Contains Statistical Tests for Normal Data Too
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 |
Haven't you waited long enough?
Start running Non-parametric tests in just minutes.
Download a free 30-day trial. Run Non-parametric tests on your data now!
Non-parametric tests are one of many statistical tests included in QI Macros add-in 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.
