Need to Run a Mann-Whitney Test in Excel?

QI Macros has a ready-made Mann-Whitney template for you!

Mann-Whitney sample data

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.
  5. Mann-Whitney sample data

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.


Haven't you waited long enough?
Start running Mann-Whitney tests in just minutes.

Download a free 30-day trial. Run Mann-Whitney tests on your data now!

Mann-Whitney tests are one of many statistical tests included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. You will find the statistical tools and templates on the far left side of QI Macros menu.

statistical tests in QI Macros Excel add-in

QI Macros draws these SPC charts as well