# Statistics - Example #2

## Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K
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:

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.