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?
- 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