# 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.

### Mann-Whitney Example

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

### Affordable

- Only
**$349 USD**

Quantity Discounts Available - No annual fees
- Free Technical Support