50 likes | 167 Views
ALL POSSIBLE REGRESSIONS The RSQUARE Procedure Model: MODEL1 Dependent Variable: SALES R-Square Selection Method Number in Adjusted Root
E N D
ALL POSSIBLE REGRESSIONS • The RSQUARE Procedure • Model: MODEL1 • Dependent Variable: SALES • R-Square Selection Method • Number in Adjusted Root • Model R-Square R-Square C(p) MSE SSE Variables in Model • ----------------------------------------------------------------------------------------------- • 4 0.9004 0.8805 5.1519 453.83623 4119346 POTENT ADVERT SHARE ACCOUNTS • 4 0.8960 0.8752 6.0599 463.94781 4304951 TIME POTENT ADVERT SHARE • ----------------------------------------------------------------------------------------------- • 5 0.9119 0.8888 4.8276 437.95155 3644230 POTENT ADVERT SHARE CHANGE • ACCOUNTS • 5 0.9108 0.8873 5.0560 440.74727 3690905 TIME POTENT ADVERT SHARE • CHANGE • 5 0.9064 0.8817 5.9565 451.60487 3874992 TIME POTENT ADVERT SHARE • ACCOUNTS • 5 0.9028 0.8772 6.6716 460.04338 4021158 POTENT ADVERT SHARE ACCOUNTS • WORKLOAD • 5 0.9025 0.8768 6.7397 460.83914 4035082 TIME POTENT ADVERT SHARE • RATING • 5 0.9013 0.8754 6.9716 463.53877 4082496 POTENT ADVERT SHARE ACCOUNTS • RATING • 5 0.8965 0.8692 7.9550 474.81309 4283502 TIME POTENT ADVERT SHARE • WORKLOAD • ----------------------------------------------------------------------------------------------- • 6 0.9181 0.8908 5.5848 433.98496 3390173 TIME POTENT ADVERT SHARE • CHANGE ACCOUNTS • 6 0.9173 0.8897 5.7457 436.08518 3423065 POTENT ADVERT SHARE CHANGE • ACCOUNTS WORKLOAD • 6 0.9121 0.8828 6.7968 449.56357 3637933 POTENT ADVERT SHARE CHANGE • ACCOUNTS RATING • 6 0.9119 0.8825 6.8390 450.09635 3646561 TIME POTENT ADVERT SHARE • CHANGE RATING • 6 0.9109 0.8812 7.0401 452.62529 3687654 TIME POTENT ADVERT SHARE • CHANGE WORKLOAD • ----------------------------------------------------------------------------------------------- Example
ALL POSSIBLE REGRESSIONS • The RSQUARE Procedure • Model: MODEL1 • Dependent Variable: SALES • R-Square Selection Method • Number in Adjusted Root • Model R-Square R-Square C(p) MSE SSE Variables in Model • ----------------------------------------------------------------------------------------------- • 6 0.9094 0.8792 7.3368 456.33215 3748303 TIME POTENT ADVERT SHARE • ACCOUNTS RATING • 6 0.9072 0.8762 7.7935 461.98069 3841671 TIME POTENT ADVERT SHARE • ACCOUNTS WORKLOAD • 6 0.9040 0.8720 8.4367 469.82008 3973156 POTENT ADVERT SHARE ACCOUNTS • WORKLOAD RATING • 6 0.9026 0.8702 8.7075 473.08103 4028502 TIME POTENT ADVERT SHARE • WORKLOAD RATING • ----------------------------------------------------------------------------------------------- • 7 0.9209 0.8883 7.0136 438.81025 3273425 TIME POTENT ADVERT SHARE • CHANGE ACCOUNTS WORKLOAD • 7 0.9182 0.8846 7.5492 446.08716 3382894 TIME POTENT ADVERT SHARE • CHANGE ACCOUNTS RATING • 7 0.9174 0.8834 7.7159 448.32838 3416972 POTENT ADVERT SHARE CHANGE • ACCOUNTS WORKLOAD RATING • 7 0.9120 0.8757 8.8204 462.90380 3642759 TIME POTENT ADVERT SHARE • CHANGE WORKLOAD RATING • 7 0.9102 0.8733 9.1733 467.46444 3714891 TIME POTENT ADVERT SHARE • ACCOUNTS WORKLOAD RATING • ----------------------------------------------------------------------------------------------- • 8 0.9210 0.8814 9.0000 452.12251 3270636 TIME POTENT ADVERT SHARE • CHANGE ACCOUNTS WORKLOAD • RATING Example
6-4 Other Aspects of Regression Example Summary of Forward Selection Variable Number Partial Model Step Entered Vars In R-Square R-Square C(p) F Value Pr > F 1 ACCOUNTS 1 0.5685 0.5685 66.3492 30.30 <.0001 2 ADVERT 2 0.2066 0.7751 26.5262 20.21 0.0002 3 POTENT 3 0.0526 0.8277 17.8740 6.41 0.0194 4 SHARE 4 0.0727 0.9004 5.1519 14.61 0.0011 5 CHANGE 5 0.0115 0.9119 4.8276 2.48 0.1320 6 TIME 6 0.0061 0.9181 5.5848 1.35 0.2606 7 WORKLOAD 7 0.0028 0.9209 7.0136 0.61 0.4469
6-4 Other Aspects of Regression Example Summary of Backward Elimination Variable Number Partial Model Step Removed Vars In R-Square R-Square C(p) F Value Pr > F 1 RATING 7 0.0001 0.9209 7.0136 0.01 0.9085 2 WORKLOAD 6 0.0028 0.9181 5.5848 0.61 0.4469 3 TIME 5 0.0061 0.9119 4.8276 1.35 0.2606 4 CHANGE 4 0.0115 0.9004 5.1519 2.48 0.1320
6-4 Other Aspects of Regression Example Summary of Stepwise Selection Variable Variable Number Partial Model Step Entered Removed Vars In R-Square R-Square C(p) F Value Pr > F 1 ACCOUNTS 1 0.5685 0.5685 66.3492 30.30 <.0001 2 ADVERT 2 0.2066 0.7751 26.5262 20.21 0.0002 3 POTENT 3 0.0526 0.8277 17.8740 6.41 0.0194 4 SHARE 4 0.0727 0.9004 5.1519 14.61 0.0011 5 CHANGE 5 0.0115 0.9119 4.8276 2.48 0.1320