Tutorial - Wilcoxon 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 Wilcoxon test analysis is performed on the fictitious banking data to analyze account usage.

  1. Parameterize a Wilcoxon Test analysis as follows:
    • Available Tables — twm_customer_analysis
    • First Column — avg_ck_bal
    • Second Column — avg_sv_bal
    • Group By Columns — years_with_bank
    • Analysis Parameters
      • Threshold Probability — 0.05
      • Single Tail — false (default)
      • Include Zero — false (default)
  2. Run the analysis.
  3. Click Results when it completes.
    For this example, the Wilcoxon Test analysis generated the following table. The Wilcoxon Test was computed for each distinct value of the group by variable “gender”. The tests show the samples of avg_ck_bal and avg_sv_bal came from populations with the same mean or median for customers with years_with_bank of 0, 4-9, and from populations with different means or medians for those with years_with_bank of 1-3. An ‘n’ or ‘p’ means significant and an ‘a’ means accept the null hypothesis.
    The SQL is available for viewing but not listed below.
    Wilcoxon Test
    years_with_bank N Z_ WilcoxonPValue WilcoxonCallP_0.05
    0 75 -1.77163 0.07639 a
    1 77 -3.52884 0.00042 n
    2 83 -2.94428 0.00324 n
    3 69 -2.03882 0.04145 n
    4 69 -0.56202 0.57412 a
    5 67 -1.95832 0.05023 a
    6 65 -1.25471 0.20948 a
    7 48 -0.44103 0.65921 a
    8 39 -1.73042 0.08363 a
    9 33 -1.45623 0.14539 a