-
Parameterize a Statistical analysis as follows:
-
Columns to Analyze
- twm_customer.income
- twm_customer.age
-
Extended Statistics Options
- Values
- Modes
- Quantiles
- Rank
-
Columns to Analyze
-
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.