-
Parameterize a Histogram analysis as follows:
- Columns to Analyze — twm_customer.income
-
Bin Style — Bins with Boundaries
- Minimum — 10000
- Maximum — 100000
- Run the analysis.
-
When it completes, click in the RESULTS tab.
For this example, the Histogram analysis generated the following results. Again, the SQL is not shown.
Histogram Analysis Example #4 Table xtbl xcol xbin xbeg xend xcnt xpct twm_customer income 0 10000.00 252.00 33.73 twm_customer income 1 10000.00 19000.00 152.00 20.35 twm_customer income 2 19000.00 28000.00 114.00 15.26 twm_customer income 3 28000.00 37000.00 82.00 10.98 twm_customer income 4 37000.00 46000.00 56.00 7.50 twm_customer income 5 46000.00 55000.00 25.00 3.35 twm_customer income 6 55000.00 64000.00 26.00 3.48 twm_customer income 7 64000.00 73000.00 8.00 1.07 twm_customer income 8 73000.00 82000.00 11.00 1.47 twm_customer income 9 82000.00 91000.00 10.00 1.34 twm_customer income 10 91000.00 100000.00 4.00 0.54 twm_customer income 11 100000.00 7.00 0.94 Histogram Analysis Example #4 Graph
Although 10 bins were requested, 12 were generated - bin 0 and bin 11. These bins represent those values less than the minimum specified (bin 0) and greater than the maximum specified (bin 11).