# Need to Run a Mann-Whitney Test in Excel?

#### When Should You 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 Using QI Macros Template

A professor wants to compare the grades of students who attended live lectures vs video-taped lectures. The scores of students attending video lectures are in column A; those attending live lectures are in column B.

To conduct a test using QI Macros:

1. Click on the QI Macros menu > Stat Templates > Mann-Whitney to open the non-parametric test template. Then select the Mann-Whitney tab.
2. Input the data for Sample 1 (Video Taped Lectures) into column A and the data for Sample 2 (Live Lectures) into column B.
3. QI Macros will perform the calculations and display the results in columns C:G.
4. QI Macros will also interpret the results for you in cell F:17.

### QI Macros Interprets the Mann-Whitney Test Results for You!

QI Macros template interprets the results for you in cell F17. Since p (0.758) is greater than alpha (0.05) we cannot reject 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 you would Reject the Null Hypothesis.