Statistics - Example #2 - 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 Statistical analysis as follows:
    • Columns to Analyze
      • twm_customer.income
      • twm_customer.age
    • Extended Statistics Options
      • Values
      • Modes
      • Quantiles
      • Rank
  2. Run the analysis in the same manner described above.

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

    Data table pivoted for readability.
    Statistics - Example #2 Data
    xtbl TWM_CUSTOMER TWM_CUSTOMER
    xcol Income age
    xnull 0 0
    xunique 640 77
    xblank 0 0
    xzero 102 0
    xpos 645 747
    xneg 0 0
    xmode 0 15
    xmode_cnt 102 32
    xmode_pct 13.6546185 4.2838019
    xnbrmodes 1 1
    xpctile0 0 13
    xpctile1 0 13
    xpctile2 0 13
    xpctile3 0 14
    xpctile4 0 14
    xpctile5 0 15
    xpctile6 0 15
    xpctile7 0 15
    xpctile8 0 15
    xpctile9 0 16
    xpctile10 0 16
    xpctile20 4859 22
    xpctile25 7083 28
    xpctile30 8575 31
    xpctile33 9738 32
    xpctile40 12485 36
    xpctile50 17242 42
    xpctile60 22025 48
    xpctile67 26548 52
    xpctile70 28518 54
    xpctile75 31379 56
    xpctile80 36761 59
    xpctile90 50704 68
    xpctile91 54713 69
    xpctile92 56384 70
    xpctile93 57723 73
    xpctile94 60242 74
    xpctile95 66930 77
    xpctile96 75890 79
    xpctile97 79057 80
    xpctile98 86055 83
    xpctile99 98566 85
    xpctile100 144157 89
    xmin_1 0 13
    xmin_2 1039 14
    xmin_3 1565 15
    xmin_4 1591 16
    xmin_5 1814 17
    xmincnt_1 102 15
    xmincnt_2 1 15
    xmincnt_3 1 32
    xmincnt_4 1 19
    xmincnt_5 1 21
    xmax_5 111004 85
    xmax_4 127848 86
    xmax_3 129196 87
    xmax_2 142274 88
    xmax_1 144157 89
    xmaxcnt_5 1 1
    xmaxcnt_4 1 1
    xmaxcnt_3 1 1
    xmaxcnt_2 1 3
    xmaxcnt_1 1 2
    No graphs are available for these Stats Options.