Statistics - 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 Statistical analysis as follows:
    • Columns to Analyze
      • twm_customer.income
      • twm_customer.age
    • Columns to Group By — gender
    • Statistics Options
      • Number of Values
      • Minimum Value
      • Maximum Value
      • Mean Value
      • Standard Deviation
  2. Run the analysis in the same manner described above.

    This time, the following Results were generated. Again, the SQL is not shown:

    Statistics - Example #3 Data
    gender xtbl xcol xcnt xmin xmax xmean xstd
    M TWM_CUSTOMER income 329 0 144157 26405.6930091 25700.3655032
    F TWM_CUSTOMER income 418 0 102286 19833.8588517 18472.7539608
    M TWM_CUSTOMER age 329 13 88 42.662614 19.4246694
    F TWM_CUSTOMER age 418 13 89 42.3349282 18.8430378
    Statistics Example #3 Graph

    As above, thumbnails are displayed, this time for each column and each group by column value, in box and whisker format. As the mouse passes over each thumbnail, the cursor changes to indicate a hyperlink, and the individual graphs can be maximized by clicking on the thumbnail.