Histogram - Example #4 - 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 Histogram analysis as follows:
    • Columns to Analyze — twm_customer.income
    • Bin Style — Bins with Boundaries
      • Minimum — 10000
      • Maximum — 100000
  2. Run the analysis.
  3. When it completes, click in the RESULTS tab.

    For this example, the Histogram analysis generated the following results. Again, the SQL is not shown.

    Histogram Analysis Example #4 Table
    xtbl xcol xbin xbeg xend xcnt xpct
    twm_customer income 0   10000.00 252.00 33.73
    twm_customer income 1 10000.00 19000.00 152.00 20.35
    twm_customer income 2 19000.00 28000.00 114.00 15.26
    twm_customer income 3 28000.00 37000.00 82.00 10.98
    twm_customer income 4 37000.00 46000.00 56.00 7.50
    twm_customer income 5 46000.00 55000.00 25.00 3.35
    twm_customer income 6 55000.00 64000.00 26.00 3.48
    twm_customer income 7 64000.00 73000.00 8.00 1.07
    twm_customer income 8 73000.00 82000.00 11.00 1.47
    twm_customer income 9 82000.00 91000.00 10.00 1.34
    twm_customer income 10 91000.00 100000.00 4.00 0.54
    twm_customer income 11 100000.00   7.00 0.94
    Histogram Analysis Example #4 Graph

    Although 10 bins were requested, 12 were generated - bin 0 and bin 11. These bins represent those values less than the minimum specified (bin 0) and greater than the maximum specified (bin 11).