Frequency - Example #2 - 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 Frequency analysis as follows:
    • Columns to Analyze
      • twm_customer.gender
      • twm_customer.marital_status
    • Frequency Style — Cross-Tabulation
  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 #2 Data
    gender marital_status xcnt xpct
    F 2 189 25.3012048
    M 2 164 21.9544846
    F 1 159 21.2851406
    M 1 117 15.6626506
    F 4 40 5.3547523
    F 3 30 4.0160643
    M 4 30 4.0160643
    M 3 18 2.4096386
    Frequency Analysis Example #2 Graph

    Note that the “gender” column cross-tabulated with “marital_status” take on the values of “1” and “F” respectively 159 times.

  3. Click on the Graph Options tab as described above to change the view to three dimensions.
    Frequency Analysis Example #2 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.