Frequency - Example #1

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K
  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.”