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
- Skewed data that make the median more representative
List of the Non-Parametric Tests in QI Macros
|Variable (Continuous) Data||1||2||3|
|Goodness of Fit||Kolmogorov-Smirnov (K-S)||Tukey|
|Attribute (Ordinal Data|
|Independent||1-Sample Sign Test||Sign Test|
QI Macros Contains Statistical Tests for Normal Data Too
Non-Normal vs Normal Tests
|1-Sample Sign||1-Sample z-Test
|Sign Test||Paired Two-Sample t-Test|
|Wilcoxon Signed Rank Test|
Wilcoxon Rank Sum Test
|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.
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.