Frequency - Example #4 - 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
    • Include rank, cumulative count, and cumulative percentage… — Enabled
  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 #4 Data
    gender marital_status xcnt xpct xcum_cnt xcum_pct xrank
    F 2 189 25.3012048 189 25.3012048 1
    M 2 164 21.9544846 353 47.2556894 2
    F 1 159 21.2851406 512 68.54083 3
    M 1 117 15.6626506 629 84.2034806 4
    F 4 40 5.3547523 669 89.5582329 5
    F 3 30 4.0160643 699 93.5742972 6
    M 4 30 4.0160643 729 97.5903614 7
    M 3 18 2.4096386 747 100 8

    Note that clicking on the Frequency Graph page will by default bring up the same two-dimensional or three dimensional graph as in Frequency - Example #2.

  3. Click on the Graph Options tab and select Show cumulative statistics to view the following graph.
    Frequency Analysis Example #4 Graph

    Note that the raw frequency counts are plotted by a red bar, while the cumulative statistics are shown in blue.