Tutorial 3 - Mann-Whitney Independent Tests 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 Independent Tests analysis is performed on the fictitious banking data to analyze account usage.

  1. Parameterize a Mann-Whitney Independent Tests analysis as follows:
    • Available Tables — twm_customer_analysis
    • Column of Interest — income
    • Columns — gender, ccacct, ckacct, svacct
    • Group By Columns
    • Analysis Parameters
      • Threshold Probability — 0.05
      • Single Tail — false (default)
  2. Run the analysis.
  3. Click Results when it completes.
    For this example, the Mann-Whitney Independent Tests analysis generated the following table. The Mann-Whitney Test was computed separately for each independent variable. The tests show that customer incomes by gender and by svacct were from different populations, and that customer incomes by ckacct and by ccacct were from identical populations.
    The SQL is available for viewing but not listed below.
    Mann-Whitney Test
    _twm_independent Z MannWhitneyPValue MannWhitneyCallP_0.05
    gender -3.00331351 0.002673462 n
    svacct -3.37298401 0.000743646 n
    ckacct -1.92490664 0.05422922 a
    ccacct 1.764991014 0.077563672 a