Friedman Test in Excel using the QI Macros

When to Use the Friedman Test

A Friedman test is like a two-way ANOVA. Consider the following example.

Test Example

A pharmacutical company wants to compare the reaction time for four drugs (A-D). Each drug is given to five subjects and reaction time is measured. The null hypothesis is that reaction times for the four drugs are the same.

Hypothesis Test: Since p (0.989) is greater than alpha (0.05) accept the null hypothesis that the reaction times are the same.

Watch Non-parametric tests in Excel Video

The Friedman test is just one of the tests included in the QI Macros Statistical Process Control software. Other tests include:

• Overvew of all hypothesis tests in Excel
• Other Non parametric tests in Excel in the QI Macros

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma