In this example, the same table is scored as was used to build the Factor analysis model.
-
Parameterize a Factor Analysis Scoring Analysis as follows:
- Selected Table — twm_customer_analysis
- Evaluate and Score — Enabled
-
Factor Names
- Factor1
- Factor2
- Factor3
- Factor4
- Factor5
- Factor6
- Factor7
- Result Table Name — twm_score_factor_1
- Index Columns — cust_id
- Run the analysis.
-
Click Results when it completes.
For this example, the Factor Analysis Scoring/Evaluation function generated the following pages. A single click on each page name populates Results with the item.
Factor Analysis Score Report Resulting Scored Table <result_db >.score_factor_1 Number of Rows in Scored Table 747 Evaluation Variable Name Standard Error of Estimate income 0.4938 age 0.5804 years_with_bank 0.5965 nbr_children 0.6180 female 0.8199 single 0.3013 married 0.3894 separated 0.4687 ccacct 0.6052 ckacct 0.5660 svacct 0.5248 avg_cc_bal 0.4751 avg_ck_bal 0.6613 avg_sv_bal 0.7166 avg_cc_tran_amt 0.8929 avg_cc_tran_cnt 0.5174 avg_ck_tran_amt 0.3563 avg_ck_tran_cnt 0.7187 avg_sv_tran_amt 0.4326 avg_sv_tran_cnt 0.6967 cc_rev 0.3342 Data cust_id factor1 factor2 factor3 factor4 factor5 factor6 factor7 1362480 1.43 -0.28 1.15 -0.50 -0.31 -0.05 1.89 1362481 -1.03 -1.37 0.57 -0.08 -0.60 -0.39 -0.55 ... ... ... ... ... ... ... ...