Histogram - Example #1 - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
apa1503087321277.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. Parameterize a Histogram analysis as follows:
    • Histogram Style — Basic
    • Columns to Analyze
      • twm_customer.age
      • twm_customer.income
  2. Run the analysis, and when it completes, click in the RESULTS tab.

    For this example, the Histogram analysis generated the following results. Note that the SQL is not shown for brevity:

    Histogram Analysis Example # 1 Data
    xtbl xcol xbin xbeg xend xcnt xpct
    TWM_CUSTOMER age 1 13 20.6 140 18.7416332
    TWM_CUSTOMER age 2 20.6 28.2 56 7.4966533
    TWM_CUSTOMER age 3 28.2 35.8 92 12.3159304
    TWM_CUSTOMER age 4 35.8 43.4 107 14.3239625
    TWM_CUSTOMER age 5 43.4 51 88 11.7804552
    TWM_CUSTOMER age 6 51 58.6 110 14.7255689
    TWM_CUSTOMER age 7 58.6 66.2 71 9.5046854
    TWM_CUSTOMER age 8 66.2 73.8 35 4.6854083
    TWM_CUSTOMER age 9 73.8 81.4 28 3.7483266
    TWM_CUSTOMER age 10 81.4 89 20 2.6773762
    TWM_CUSTOMER income 1 0 14415.7 332 44.4444444
    TWM_CUSTOMER income 2 14415.7 28831.4 191 25.5689424
    TWM_CUSTOMER income 3 28831.4 43247.1 108 14.4578313
    TWM_CUSTOMER income 4 43247.1 57662.8 63 8.4337349
    TWM_CUSTOMER income 5 57662.8 72078.5 20 2.6773762
    TWM_CUSTOMER income 6 72078.5 86494.2 19 2.5435074
    TWM_CUSTOMER income 7 86494.2 100909.9 7 .9370817
    TWM_CUSTOMER income 8 100909.9 115325.6 3 .4016064
    TWM_CUSTOMER income 9 115325.6 129741.3 2 .2677376
    TWM_CUSTOMER income 10 129741.3 144157 2 .2677376
    Histogram Analysis Example #1 Graph

    Note that the “age” column ranges from the value “13” to “89,” and that the first bin range is 13-20.6, where there are 140 occurrences.

  3. Click on the Graph Options tab as described above to change the data being graphed from “age” to “income.”