Home » Statistical Analysis Excel » Mood's Median Test

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.

 

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?