Frequency - Example #3 - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. Parameterize a Frequency analysis as follows:
    • Columns to Analyze
      • twm_customer.gender
      • twm_customer.marital_status
    • Pairwise Columns to Analyze — nbr_children
    • Frequency Style — Pair-wise
  2. Run the analysis in the same manner described above.

    This time, the following Results were generated. Again, not all SQL is shown.

    Frequency Analysis Example #3 Data
    xtbl col1 val1 col2 val2 xcnt xpct
    TWM_CUSTOMER marital_status 1 nbr_children 0 276 36.9477912
    TWM_CUSTOMER gender F nbr_children 0 260 34.8058902
    TWM_CUSTOMER gender M nbr_children 0 206 27.5769746
    TWM_CUSTOMER marital_status 2 nbr_children 0 156 20.8835341
    TWM_CUSTOMER marital_status 2 nbr_children 1 85 11.3788487
    TWM_CUSTOMER marital_status 2 nbr_children 2 78 10.4417671
    TWM_CUSTOMER gender F nbr_children 1 64 8.5676037
    TWM_CUSTOMER gender F nbr_children 2 64 8.5676037
    TWM_CUSTOMER gender M nbr_children 1 50 6.6934404
    TWM_CUSTOMER gender M nbr_children 2 46 6.1579652
    TWM_CUSTOMER marital_status 2 nbr_children 3 24 3.2128514
    TWM_CUSTOMER gender F nbr_children 3 21 2.811245
    TWM_CUSTOMER marital_status 4 nbr_children 1 20 2.6773762
    TWM_CUSTOMER marital_status 4 nbr_children 0 18 2.4096386
    TWM_CUSTOMER gender M nbr_children 3 17 2.2757697
    TWM_CUSTOMER marital_status 3 nbr_children 2 17 2.2757697
    TWM_CUSTOMER marital_status 3 nbr_children 0 16 2.1419009
    TWM_CUSTOMER marital_status 4 nbr_children 2 15 2.0080321
    TWM_CUSTOMER marital_status 4 nbr_children 3 10 1.3386881
    TWM_CUSTOMER marital_status 3 nbr_children 1 9 1.2048193
    TWM_CUSTOMER gender M nbr_children 5 6 .8032129
    TWM_CUSTOMER marital_status 2 nbr_children 4 5 .669344
    TWM_CUSTOMER marital_status 2 nbr_children 5 5 .669344
    TWM_CUSTOMER gender F nbr_children 4 5 .669344
    TWM_CUSTOMER marital_status 4 nbr_children 4 4 .5354752
    TWM_CUSTOMER marital_status 3 nbr_children 3 4 .5354752
    TWM_CUSTOMER gender F nbr_children 5 4 .5354752
    TWM_CUSTOMER gender M nbr_children 4 4 .5354752
    TWM_CUSTOMER marital_status 4 nbr_children 5 3 .4016064
    TWM_CUSTOMER marital_status 3 nbr_children 5 2 .2677376
    Frequency Analysis Example #3 Graph

    Note that the “gender” column taken with “nbr_children” takes on the value of “F” and “0” 260 times. Click on the Graph Options tab as described above to change the view to “marital_status” and “nbr_children”.

  3. Click on the Graph Options tab as described above to change the view to three dimensions.
    Frequency Analysis Example #3 Graph: Three-Dimensional View

    This three-dimensional view can be rotated by dragging the vertical or horizontal scroll bars, or automatically by double-clicking on the graph. The rotation can be stopped by double-clicking the image a second time.