Include Top

How Do I Perform a Two Sample Mann-Whitney Rank Test in Excel Using SigmaXL?

Two Sample Mann-Whitney Rank Test

We will look at comparing medians of Customer Satisfaction by Customer Type, using the Two Sample Mann-Whitney Rank test. (H0: Median2 = Median3, Ha: Median2 ≠ Median3.) The Two Sample Mann-Whitney Test is the nonparametric equivalent to the parametric Two Sample t-Test.

  1. Open Customer Data.xlsx, click Sheet 1 tab (or press F4 to activate last worksheet).

  2. Click SigmaXL > Statistical Tools > Nonparametric Tests > 2 Sample Mann-Whitney. If necessary, check Use Entire Data Table, click Next.

  3. With Stacked Column Format checked, select Overall Satisfaction, click Numeric Data Variable (Y) >>; select Customer Type, click Group Category (X) >>; and Ha: Not Equal To:

    2 Sample Mann-Whitney

  4. Click OK. Select Customer Type 2 and 3.

  5. Customer Type Comparison

  6. Click OK. Resulting output:

  7. Mann-Whitney Results

    Given the p-value of .0008 we reject H0 and conclude that Median Customer Satisfaction is significantly different between Customer types 2 and 3. This confirms previous findings and matches the results of the 2 Sample t-Test.

Define, Measure, Analyze, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,

Lean Six Sigma Software Excel Add-in

Web Demos

Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim
Click here to view some now!

Contact Us

Phone: 1.888.SigmaXL (744.6295)