Histogram - Example #3 - 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 Histogram analysis as follows:
    • Columns to Analyze
      • twm_customer.age
      • twm_customer.income
    • Histogram Style — Cross-Tab
  2. Run the analysis in the same manner described above.

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

    Histogram Analysis Example #3 Table
    xbin_income xbeg_income xend_income xbin_age xbeg_age xend_age xcnt xpct
    1 0 14415.7 1 13 20.6 132 17.6706827
    1 0 14415.7 2 20.6 28.2 37 4.9531459
    1 0 14415.7 3 28.2 35.8 26 3.480589
    1 0 14415.7 4 35.8 43.4 21 2.811245
    1 0 14415.7 5 43.4 51 14 1.8741633
    1 0 14415.7 6 51 58.6 11 1.4725569
    1 0 14415.7 7 58.6 66.2 34 4.5515395
    1 0 14415.7 8 66.2 73.8 16 2.1419009
    1 0 14415.7 9 73.8 81.4 22 2.9451138
    1 0 14415.7 10 81.4 89 19 2.5435074
    2 14415.7 28831.4 1 13 20.6 8 1.0709505
    2 14415.7 28831.4 2 20.6 28.2 17 2.2757697
    2 14415.7 28831.4 3 28.2 35.8 31 4.1499331
    2 14415.7 28831.4 4 35.8 43.4 32 4.2838019
    2 14415.7 28831.4 5 43.4 51 36 4.8192771
    2 14415.7 28831.4 6 51 58.6 25 3.3467202
    2 14415.7 28831.4 7 58.6 66.2 21 2.811245
    2 14415.7 28831.4 8 66.2 73.8 15 2.0080321
    2 14415.7 28831.4 9 73.8 81.4 5 .669344
    2 14415.7 28831.4 10 81.4 89 1 .1338688
    3 28831.4 43247.1 2 20.6 28.2 2 .2677376
    3 28831.4 43247.1 3 28.2 35.8 16 2.1419009
    3 28831.4 43247.1 4 35.8 43.4 29 3.8821954
    3 28831.4 43247.1 5 43.4 51 16 2.1419009
    3 28831.4 43247.1 6 51 58.6 31 4.1499331
    3 28831.4 43247.1 7 58.6 66.2 10 1.3386881
    3 28831.4 43247.1 8 66.2 73.8 3 .4016064
    3 28831.4 43247.1 9 73.8 81.4 1 .1338688
    4 43247.1 57662.8 3 28.2 35.8 16 2.1419009
    4 43247.1 57662.8 4 35.8 43.4 14 1.8741633
    4 43247.1 57662.8 5 43.4 51 12 1.6064257
    4 43247.1 57662.8 6 51 58.6 14 1.8741633
    4 43247.1 57662.8 7 58.6 66.2 6 .8032129
    4 43247.1 57662.8 8 66.2 73.8 1 .1338688
    5 57662.8 72078.5 3 28.2 35.8 1 .1338688
    5 57662.8 72078.5 4 35.8 43.4 3 .4016064
    5 57662.8 72078.5 5 43.4 51 5 .669344
    5 57662.8 72078.5 6 51 58.6 11 1.4725569
    6 72078.5 86494.2 3 28.2 35.8 2 .2677376
    6 72078.5 86494.2 4 35.8 43.4 7 .9370817
    6 72078.5 86494.2 5 43.4 51 2 .2677376
    6 72078.5 86494.2 6 51 58.6 8 1.0709505
    7 86494.2 100909.9 4 35.8 43.4 1 .1338688
    7 86494.2 100909.9 5 43.4 51 2 .2677376
    7 86494.2 100909.9 6 51 58.6 4 .5354752
    8 100909.9 115325.6 5 43.4 51 1 .1338688
    8 100909.9 115325.6 6 51 58.6 2 .2677376
    9 115325.6 129741.3 6 51 58.6 2 .2677376
    10 129741.3 144157 6 51 58.6 2 .2677376
  3. Go to the Graph Options tab.
  4. Select the 3D Graph radio buttons. This graph is shown below.
    Histogram Analysis Example #3 Graph: Three-Dimensional Display

    Here, the three-dimensional graph shows a Cross-Tabulation of each bin of “income” and “age.” As an example, look at the tallest bar, the Cross-Tabulation of “income” within the range of 0-14415.7, with the age column in the range of 13-20.6. There are approximately 130 occurrences within that particular Cross-Tabulation.

  5. Click on the Graph Options tab as described above to change the axis that the columns are displayed on, and a two-dimensional stacked view of the cross-tabulated results.