In this example, a Mann-Whitney test analysis is performed on the fictitious banking data to analyze account usage.
-
Parameterize a Mann-Whitney Test analysis as follows:
- Available Tables — twm_customer
- Column of Interest — income
- Columns — gender (2 distinct values -> Mann-Whitney test)
- Group By Columns — years_with_bank
-
Analysis Parameters
- Threshold Probability — 0.01
- Single Tail — false (default)
- Run the analysis.
-
Click Results when it completes.
For this example, the Mann-Whitney Test analysis generated the following table. The Mann-Whitney Test was computed for each distinct value of the group by variable “years_with_bank”. Results were sorted by years_with_bank. The tests show that customer incomes by gender were from the same population for all values of years_with_bank (an ‘a’ means accept the null hypothesis).The SQL is available for viewing but not listed below.
Mann-Whitney Test years_with_bank Z MannWhitneyPValue MannWhitneyCallP_0.01 0 -0.0127 0.9896 a 1 -0.2960 0.7672 a 2 -0.4128 0.6796 a 3 -0.6970 0.4858 a 4 -1.8088 0.0705 a 5 -2.2541 0.0242 a 6 -0.8683 0.3854 a 7 -1.7074 0.0878 a 8 -0.8617 0.3887 a 9 -0.4997 0.6171 a