Multiple Regression Example Tuesday - SUMMARY OUTPUT...

This preview shows page 1 - 15 out of 50 pages.

SUMMARY OUTPUT Regression Statistics Multiple R 0.960230559 R Square 0.9220427265 Adjusted R Square 0.8830640897 Standard Error 449.0153681329 Observations 25 ANOVA df SS MS F Significance F Regression 8 38153712.11374 4769214 23.65508 1.814945E-007 Residual 16 3225836.813112 201614.8 Total 24 41379548.92686 Coefficients Standard Error t Stat P-value Lower 95% Intercept -1507.83577778 778.6084145786 -1.936578 0.070663 -3158.4118819 Time 2.0101369027 1.9305144468 1.041244 0.313241 -2.0823709034 Poten 0.0372055722 0.0082021598 4.53607 0.000337 0.0198177701 AdvExp 0.1509836587 0.0471069017 3.205128 0.005518 0.0511214882 Share 199.0401821274 67.0291490165 2.969457 0.009037 56.944733925 Change 290.8665748285 186.7768725549 1.557294 0.138958 -105.08270707 Accounts 5.5497447884 4.775443082 1.162142 0.26222 -4.5737423073 Work 19.7938935856 33.6751714363 0.587789 0.564878 -51.594280794 Rating 8.1890347094 128.4984664051 0.063729 0.949976 -264.21554516 RESIDUAL OUTPUT PROBABILITY OUTPUT Observation Predicted Sales Residuals Percentile Sales 22 2585.144717652 -549.394717652 2 1578 19 3796.944128085 -532.744128085 6 1741.45 20 3975.052033518 -521.432033518 10 2035.75 2 3881.215129707 -407.265129707 14 2134.94 24 4549.346514975 -381.906514975 18 2295.1 3 2617.148953532 -322.048953532 22 2337.38 7 5286.065026653 -254.405026653 26 2408.11 23 1728.943706474 -150.943706474 30 2468.27 4 4825.91384685 -150.35384685 34 2533.31 15 4731.611301127 -144.661301127 38 2729.24 11 2567.538546666 -99.2685466664 42 2799.97 16 2813.012803352 -83.7728033522 46 2800.78 17 3355.535970233 -66.1359702333 50 3264.2 18 2804.302950351 -3.5229503506 54 3289.4 13 2402.837791955 5.272208045 58 3367.45 14 2288.073047633 49.3069523665 62 3453.62
6 2057.824250069 77.1157499315 66 3473.95 25 2541.390172114 258.5798278859 70 3669.88 1 3378.34231133 291.5376886702 74 4167.44 9 6171.963964266 347.4860357344 78 4586.95 21 1377.005850837 364.4441491632 82 4675.56 8 2955.121298213 412.3287017868 86 4876.37 12 2093.818182906 439.4918170943 90 5031.66 5 5492.622339803 633.3376601972 94 6125.96 10 4087.415161701 788.954838299 98 6519.45
Upper 95% Lower 95.0% Upper 95.0% 142.7403 -3158.412 142.7403 6.102645 -2.082371 6.102645 0.054593 0.019818 0.054593 0.250846 0.051121 0.250846 341.1356 56.94473 341.1356 686.8159 -105.0827 686.8159 15.67323 -4.573742 15.67323 91.18207 -51.59428 91.18207 280.5936 -264.2155 280.5936 T 0.00 50.00 100.00 150.00 200 -600 -400 -200 0 200 400 Time Residual Plot Time Residuals 0.0 20000.0 40000.0 60000.0 8000 -600 -400 -200 0 200 400 Poten Residual Plot Poten Residuals 0.0 2000.0 4000.0 6000.0 8000.0 1000 -600 -400 -200 0 200 400 AdvExp Residual Plot AdvExp Residuals
0.00 00.0 00.0 0.00 2.00 4.00 6.00 8.00 10.00 12.00 14.00 -600 -400 -200 0 200 400 Share Residual Plot Share Residuals -1.00 -0.50 0.00 0.50 1.00 1.50 -600 -400 -200 0 200 400 Change Residual Plot Change Residuals 50.00 100.00 150.00 200.00 250.00 -600 -400 -200 0 200 400 Accounts Residual Plot Accounts Residuals 5.00 -600 -400 -200 0 200 400 Wor Residuals 2.5 -600 -400 -200 0 200 400 Ratin Residuals
10.00 15.00 20.00 25.00 30.00 rk Residual Plot Work 3 3.5 4 4.5 5 5.5 ng Residual Plot Rating
SUMMARY OUTPUT Regression Statistics Multiple R 0.9213987312 R Square 0.8489756219 Adjusted R Square 0.8274007108 Standard Error 545.5150751384 Observations 25 ANOVA df SS MS F Significance F Regression 3 35130228.28559 11710076 39.35013 8.430423E-009 Residual 21 6249320.641268 297586.7 Total 24 41379548.92686 Coefficients Standard Error t Stat P-value Lower 95% Intercept -1603.58214872 505.5509128984 -3.17195 0.004593 -2654.9328264 Poten 0.0542860487 0.007474124 7.263199 3.7E-007 0.038742757 AdvExp 0.1674800813 0.0442732746 3.782871 0.001091 0.0754087666 Share 282.7469264862 48.7556059381 5.79927 9.3E-006 181.354093369 RESIDUAL OUTPUT PROBABILITY OUTPUT Observation Predicted Sales Residuals Percentile Sales 3 3121.759970293 -826.659970293 2 1578 19 4004.83887284 -740.63887284 6 1741.45 22 2761.694267252 -725.944267252 10 2035.75 24 4748.451984242 -581.011984242 14 2134.94 2 4037.118147957 -563.168147957 18 2295.1 20 4004.365468164 -550.745468164 22 2337.38 15 5080.150114465 -493.200114465 26 2408.11 1 3894.358725984 -224.478725984 30 2468.27 21 1926.828786337 -185.378786337 34 2533.31 4 4830.160131631 -154.600131631 38 2729.24 18 2850.276674457 -49.4966744571 42 2799.97 23 1617.679031461 -39.6790314609 46 2800.78 25 2813.851635646 -13.8816356462 50 3264.2 6 2074.134615075 60.8053849253 54 3289.4 11 2379.481691643 88.7883083571 58 3367.45 13 2286.715071488 121.3949285122 62 3453.62 16 2549.652359435 179.5876405652 66 3473.95 17 3030.609353222 258.7906467783 70 3669.88 14 2001.176598559 336.2034014408 74 4167.44 12 2090.021156746 443.288843254 78 4586.95 9 5930.382617563 589.0673824373 82 4675.56
8 2677.532901117 689.9170988828 86 4876.37 5 5419.047639392 706.9123606077 90 5031.66 10 4131.761462525 744.6085374751 94 6125.96 7 4102.140722507 929.5192774929 98 6519.45
Upper 95% Lower 95.0% Upper 95.0% -552.231471 -2654.932826 -552.231471 0.06982934 0.038742757 0.0698293404 0.259551396 0.0754087666 0.259551396 384.1397596 181.35409337 384.1397596 T 0.0 20000.0 40000.0 600 -1000 -500 0 500 1000 Poten Residual Plot Poten Residuals 0.0 2000.0 4000.0 6000.0 -1000 -500 0 500 1000 AdvExp Residual Plot AdvExp Residuals 0.00 2.00 4.00 6.00 8.00 10 -1000 -500 0 500 1000 Share Residual Plot Share Residuals
000.0 80000.0 8000.0 10000.0 t 0.00 12.00 14.00

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture