Correlation Matrix - Example #1 - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wbc1492033894304.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. Parameterize a Correlation Matrix analysis as follows:
    • Available Tables — TWM_CUSTOMER_ANALYSIS
    • Selected Columns — Select all Numeric Columns
  2. Run the analysis.
  3. Click on Results to view the Correlation Matrix as follows

    Note that the entire matrix is not shown for brevity.

    Correlation Matrix Results Example #1 Data
      age avg_cc_bal avg_cc_tran_amt avg_cc_tran_cnt avg_ck_bal avg_ck_tran_amt ...
    age 1.0000 ? ? ? ? ? ...
    avg_cc_bal -0.1452 1.0000 ? ? ? ? ...
    avg_cc_tran_amt 0.0389 -0.2318 1.0000 ? ?   ...
    avg_cc_tran_cnt 0.0996 -0.4919 0.1720 1.0000 ? ? ...
    avg_ck_bal 0.0709 -0.3428 0.1626 0.0859 1.0000 ? ...
    avg_ck_tran_amt 0.1529 -0.4209 0.2404 0.1429 0.6371 1.0000 ...
    ... ... ... ... ... ... ... ...