# Tutorial 1 - Mann-Whitney Test Analysis - Teradata Warehouse Miner

## Teradata Warehouse Miner User Guide - Volume 3Analytic Functions

Product
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
yuy1504291362546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2302
Product Category
Software

In this example, a Mann-Whitney test analysis is performed on the fictitious banking data to analyze account usage.

1. 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)
2. Run the analysis.
3. 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