Non-Parametric Tests in Excel using QI Macros

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

Excel doesn't have the ability to do statistical tests of non-normal (i.e., not "bell shaped") data. The QI Macros, however, have a set of templates to handle non-parametric data.

Watch Non-parametric tests in Excel Video