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.

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

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?

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets p-values for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

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



  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support