# Conduct a Friedman Test in Excel

## When to Use the Friedman Test

A Friedman test is one of the many non-parametric statistical tests performed by QI Macros Add-in for Excel.

It is like a two-way ANOVA and is used to determine if **3 or more** measurements from the same group of subjects are significantly different from each other - this is determined via the Null Hypothesis output.

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

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

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.

- Click on the QI Macros menu and then select Stat Templates to open the non-parametric test template. Then, click on the "Friedman" tab.
- Input your data into the yellow shaded cells.
- QI Macros will perform the calculations for you:

**Interpreting the Results: **Since p (0.989) is greater than alpha (0.05), we cannot reject the null hypothesis (accept the null hypothesis) that the reaction times are the same.

### Why Choose QI Macros Statistical Software for Excel?

### Affordable

- Only
**$329 USD**- less with quantity discounts - No annual fees
- Free Technical Support

### Easy to Use

- Works Right in Excel
- Interprets Results for You
- Accurate Results Without Worry

### Proven and Trusted

- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free