Mood's Median Test in Excel Using QI Macros

When to Use the Mood's Median Test

A Mood's Median Test (equivalent to Mann-Whitney and Wilcoxon Rank Sum Test) is used to compare the medians for two samples to find out if they are different.

This test is the nonparametric alternative to a one way ANOVA; Nonparametric means that you don’t have to know what distribution your sample came from (i.e. a normal distribution) before running the test. That said, your samples should have been drawn from distributions with the same shape. This test has very low statistical power for samples drawn from normal distributions or short-tailed distributions.

Use this test instead of the sign test when you have two independent samples.

Note: You can use Mann-Whitney or Wilcoxon Rank Sum tests instead of Mood's Median Test, as they provide more accurate results.


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.


How to Perform a Mood's Median Test

Included in the April 2022 version of QI Macros, this template can be found in the Stat Templates drop-down menu:


Once you have selected "Moods Median Test" from the Stat Templates drop-down, select the "Mood's Median Test" tab:


Then, input your data in columns A:E and include your alpha in cell H3 (0.05 is default):


QI Macros will calculate your output and automatically provide you with your results!


QI Macros output options:

Variables are Related (Medians are the same for both groups)
Variables are Independent (Median are different for both groups)

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