-
Parameterize a Frequency analysis as follows:
-
Columns to Analyze
- twm_customer.gender
- twm_customer.marital_status
- Frequency Style — Cross-Tabulation
- Include rank, cumulative count, and cumulative percentage… — Enabled
-
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.
Frequency Analysis Example #4 Data gender marital_status xcnt xpct xcum_cnt xcum_pct xrank F 2 189 25.3012048 189 25.3012048 1 M 2 164 21.9544846 353 47.2556894 2 F 1 159 21.2851406 512 68.54083 3 M 1 117 15.6626506 629 84.2034806 4 F 4 40 5.3547523 669 89.5582329 5 F 3 30 4.0160643 699 93.5742972 6 M 4 30 4.0160643 729 97.5903614 7 M 3 18 2.4096386 747 100 8 Note that clicking on the Frequency Graph page will by default bring up the same two-dimensional or three dimensional graph as in Frequency - Example #2.
-
Click on the Graph Options tab and select Show cumulative statistics to view the following graph.
Frequency Analysis Example #4 Graph
Note that the raw frequency counts are plotted by a red bar, while the cumulative statistics are shown in blue.