In this example, the same table is scored as was used to build the linear model, as a matter of convenience. Typically, this would not be done unless the contents of the table changed since the model was built. In the case of this example, the Standard Error of Estimate can be seen to be exactly the same, 10.445, that it was when the model was built (see Tutorial - Linear Regression).
-
Parameterize a Linear Regression Scoring analysis as follows:
- Selected Table — twm_customer_analysis
- Evaluate and Score — Enabled
- Use dependent variable for predicted value column name — Enabled
- Residual column name — Residual
- Result Table Name — twm_score_linear_1
-
Index Columns — cust_id
- Run the analysis.
-
Click Results when it completes.
For this example, the Linear Regression Scoring/Evaluation analysis generated the following pages. A single click on each page name populates Results with the item.
Linear Regression Reports Resulting Scored Table <result_db>.score_linear_1 Number of Rows in Scored Table 747 Evaluation Minimum Absolute Error 0.0056 Maximum Absolute Error 65.7775 Average Absolute Error 7.2201 Standard Error of Estimate 10.4451 Data cust_id cc_rev Residual 1362480 59.188 15.812 1362481 3.412 -3.412 1362484 12.254 -.254 1362485 28.272 1.728 1362486 -9.026E-02 9.026E-02 1362487 14.325 -1.325 1362488 -5.105 5.105 1362489 69.738 12.262 1362492 53.368 .632 1362496 -5.876 5.876 … … … … … … … … …