Include Top

Home | Login | Live Help is Live Help

Included Menu

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.xls, 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.

Click here to download a Free 30-Day Trial.