5.4.5 - Tutorial - Chi Square Test Analysis - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 3Analytic Functions

Product
Teradata Warehouse Miner
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

In this example, a Chi Square test analysis is performed on the fictitious banking data to analyze account usage.

  1. Parameterize a Chi Square Test analysis as follows:
    • Available Tables — twm_customer_analysis
    • First Columns — female, single
    • Second Columns — svacct, ccacct, ckacct
    • Analysis Parameters

      Threshold Probability — 0.05

  2. Run the analysis.
  3. Click Results when it completes.
    For this example, the Chi Square Test analysis generated the following table. The Chi Square Test was computed on all combinations of pairs of the two sets of variables. Results were sorted by column1 and column2. The tests shows that probabilities observed are the same for three pairs of variables and different for three other pairs. A ‘p’ means significantly different and an ‘a’ means not significantly different.
    The SQL is available for viewing but not listed below.
    Chi Square Test (Part 1)
    column1 column2 Chisq DF Z CramersV PhiCoeff LlhChiSq
    female ccacct 3.2131312 1 1.480358596 0.065584911 0.065584911 3.21543611
    female ckacct 8.2389731 1 2.634555949 0.105021023 0.105021023 8.23745744
    female svacct 3.9961257 1 1.716382791 0.073140727 0.073140727 3.98861957
    single ccacct 6.9958187 1 2.407215881 0.096774063 0.096774063 7.01100739
    single ckacct 0.6545145 1 0.191899245 0.02960052 0.02960052 0.65371179
    single svacct 1.5387084 1 0.799100586 0.045385576 0.045385576 1.53297321
    Chi Square Test (Part 2)
    column1 column2 ContAdjChiSq ContinCoeff ChiPValue ChiPText ChiCallP_0.05
    female ccacct 2.954339388 0.065444311 0.077657185   a
    female ckacct 7.817638955 0.10444661 0.004512106   p
    female svacct 3.697357526 0.072945873 0.046729867   p
    single ccacct 6.600561728 0.096324066 0.00854992   p
    single ckacct 0.536617115 0.029587561 0.25 >0.25 a
    single svacct 1.35045989 0.045338905 0.226624385   a