Frequency - Example #2

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
    • 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.