# Looking for a Friedman Test Template in Excel?

#### When Should You Use the Friedman Test?

The Friedman Test is like a two-way ANOVA test and is used to determine if 3 or more measurements from the same group of subjects are significantly different from each other.

Note: Excel does not do statistical tests of non-normal data (i.e. data that is not "bell shaped.") QI Macros adds this functionality with a set of of non-parametric test templates.

### Example of a Friedman Test Using QI Macros Excel Template

A pharmaceutical 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. To run a Friedman Test:

1. Open the template by clicking on QI Macros menu > Stat Templates > Friedman.
3. QI Macros will perform the calculations for you:

### Interpreting the Friedman Test Results

Since p (0.989) is greater than alpha (0.05), we cannot reject the null hypothesis that the reaction times are the same. In laymans terms we "accept the null hypothesis" - the reaction times are "the same".