Frequency - Example #1 - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
apa1503087321277.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
      • twm_customer.nbr_children
  2. Run the analysis.
  3. When it completes, click the RESULTS tab.

    For this example, the Frequency analysis generated the following results. Note that the SQL is not shown for brevity.

    Frequency Analysis - Example #1 Data
    xtbl xcol xval xcol xpct
    TWM_CUSTOMER gender F 418 55.957162
    TWM_CUSTOMER gender M 329 44.042838
    TWM_CUSTOMER marital_status 2 353 47.2556894
    TWM_CUSTOMER marital_status 1 276 36.9477912
    TWM_CUSTOMER marital_status 4 70 9.3708166
    TWM_CUSTOMER marital_status 3 48 6.4257028
    TWM_CUSTOMER nbr_children 0 466 62.3828648
    TWM_CUSTOMER nbr_children 1 114 15.2610442
    TWM_CUSTOMER nbr_children 2 110 14.7255689
    TWM_CUSTOMER nbr_children 3 38 5.0870147
    TWM_CUSTOMER nbr_children 5 10 1.3386881
    TWM_CUSTOMER nbr_children 4 9 1.2048193
    Frequency Analysis - Example #1 Graph

    Note that the “gender” column takes on the value of “F” 418 times, and the value “M” 329 times. Click on the Graph Options tab as described above to change the data being graphed from “gender” to “marital_status,” or “nbr_children.”