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

Teradata Warehouse Miner User Guide - Volume 3Analytic Functions

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
lov1499730320967.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