Mann-Whitney Test in Excel Using QI Macros
When to Use the Mann-Whitney Test
A Mann-Whitney test (equivalent to Wilcoxon Rank Sum Test) compares the differences between two independent samples to determine if they differ in location.
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.
A professor wants to compare the grades of students who attended live lectures vs video-taped lectures. Scores of students attending video lectures is in column A; live lectures in column B.
To conduct a test using QI Macros he will:
- Click on the QI Macros menu > Stat Templates > Mann Whitney
- Input the data for Sample 1 (Video Taped Lectures) into column A and the data for Sample 2 (Live Lectures) into column B.
- QI Macros will perform the calculations and display the results in columns C:G.
- QI Macros will also interpret the results for you. Cell F7 indicates that we cannot reject the null hypothesis (accept the null hypothesis):
Interpreting the Mann Whitney Test Results: Since p (0.758) is greater than alpha (0.05) we cannot reject the null hypothesis (accept the null hypothesis) that video instruction is as good as live instruction.
Tip: As you enter additional rows of data in columns A and B, the formulas in columns C and D should be automatically extended. If they do not extend, you can extend them yourself using copy and paste.
NOTE: If p < 0.05 Reject the Null Hypothesis.
Why Choose QI Macros Statistical Software for Excel?
Easy to Use
- Works Right in Excel
- Interprets p-values for You
- Accurate No-Worry Results
- Free Training Anytime
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