Frequency - Example #5 - 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
    • Columns for Statistical Analysis — twm_customer.income
    • Frequency Style — Basic
  2. Run the analysis in the same manner described above.

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

    Frequency Analysis Example #5 Data
    xtbl xcol xval xcnt xpct xmin_income xmax_income xmean_inocme xstd_income
    twm_customer gender F 418 55.96 0.00 102286.00 19833.86 18472.75
    twm_customer gender M 329 44.04 0.00 144157.00 26405.69 25700.37
    twm_customer marital_status 2 353 47.26 1039.00 144157.00 26587.44 21107.38
    twm_customer marital_status 1 276 36.95 0.00 111004.00 14167.23 18384.49
    twm_customer marital_status 4 70 9.37 2772.00 90248.00 26914.53 21090.97
    twm_customer marital_status 3 48 6.43 3303.00 142274.00 37468.50 31971.36
  3. Click on Graph Options.
  4. Select Show Counts and Statistics.
    Frequency Analysis Example #5 Graph

    Note that box and whisker plots are shown for income when gender is F and M in the lower display. In the upper display, the total counts for gender are shown.