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:

  1. Click on the QI Macros menu > Stat Templates > Mann Whitney
  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. Cell F7 indicates that we cannot reject the null hypothesis (accept the null hypothesis):
  5. Mann-Whitney sample data

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

Easy to Use

  • Works Right in Excel
  • Interprets p-values for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

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