-
Parameterize a Frequency analysis as follows:
-
Columns to Analyze:
- twm_customer.gender
- twm_customer.marital_status
- twm_customer.nbr_children
-
Columns to Analyze:
- Run the analysis.
-
When it completes, click the RESULTS tab.
For this example, the Frequency analysis generated the following results. Note that the SQL is not shown for brevity.
Frequency Analysis - Example #1 Data xtbl xcol xval xcol xpct TWM_CUSTOMER gender F 418 55.957162 TWM_CUSTOMER gender M 329 44.042838 TWM_CUSTOMER marital_status 2 353 47.2556894 TWM_CUSTOMER marital_status 1 276 36.9477912 TWM_CUSTOMER marital_status 4 70 9.3708166 TWM_CUSTOMER marital_status 3 48 6.4257028 TWM_CUSTOMER nbr_children 0 466 62.3828648 TWM_CUSTOMER nbr_children 1 114 15.2610442 TWM_CUSTOMER nbr_children 2 110 14.7255689 TWM_CUSTOMER nbr_children 3 38 5.0870147 TWM_CUSTOMER nbr_children 5 10 1.3386881 TWM_CUSTOMER nbr_children 4 9 1.2048193 Frequency Analysis - Example #1 Graph
Note that the “gender” column takes on the value of “F” 418 times, and the value “M” 329 times. Click on the Graph Options tab as described above to change the data being graphed from “gender” to “marital_status,” or “nbr_children.”