-
Parameterize a Histogram analysis as follows:
- Histogram Style — Basic
-
Columns to Analyze
- twm_customer.age
- twm_customer.income
-
Run the analysis, and when it completes, click in the RESULTS tab.
For this example, the Histogram analysis generated the following results. Note that the SQL is not shown for brevity:
Histogram Analysis Example # 1 Data xtbl xcol xbin xbeg xend xcnt xpct TWM_CUSTOMER age 1 13 20.6 140 18.7416332 TWM_CUSTOMER age 2 20.6 28.2 56 7.4966533 TWM_CUSTOMER age 3 28.2 35.8 92 12.3159304 TWM_CUSTOMER age 4 35.8 43.4 107 14.3239625 TWM_CUSTOMER age 5 43.4 51 88 11.7804552 TWM_CUSTOMER age 6 51 58.6 110 14.7255689 TWM_CUSTOMER age 7 58.6 66.2 71 9.5046854 TWM_CUSTOMER age 8 66.2 73.8 35 4.6854083 TWM_CUSTOMER age 9 73.8 81.4 28 3.7483266 TWM_CUSTOMER age 10 81.4 89 20 2.6773762 TWM_CUSTOMER income 1 0 14415.7 332 44.4444444 TWM_CUSTOMER income 2 14415.7 28831.4 191 25.5689424 TWM_CUSTOMER income 3 28831.4 43247.1 108 14.4578313 TWM_CUSTOMER income 4 43247.1 57662.8 63 8.4337349 TWM_CUSTOMER income 5 57662.8 72078.5 20 2.6773762 TWM_CUSTOMER income 6 72078.5 86494.2 19 2.5435074 TWM_CUSTOMER income 7 86494.2 100909.9 7 .9370817 TWM_CUSTOMER income 8 100909.9 115325.6 3 .4016064 TWM_CUSTOMER income 9 115325.6 129741.3 2 .2677376 TWM_CUSTOMER income 10 129741.3 144157 2 .2677376 Histogram Analysis Example #1 Graph
Note that the “age” column ranges from the value “13” to “89,” and that the first bin range is 13-20.6, where there are 140 occurrences.
- Click on the Graph Options tab as described above to change the data being graphed from “age” to “income.”