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

Two Sample Mann-Whitney Rank 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:
   
   
   
   
4. Click OK. Select Customer Type 2 and 3.




5. Click OK. Resulting output:



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.