Barry Lee decides that the simple regression analysis used in Problem 10-42 could be extended to a multiple regression analysis. He finds the following results for two multiple regression analyses:

The coefficients of correlation between combinations of pairs of the variables are as follows:

1. Evaluate regression 4 using the criteria of economic plausibility, goodness of fit, significance of in-dependent variables, and specification analysis. Compare regression 4 with regressions 2 and 3 in Problem 10-42. Which one of these models would you recommend that Lee use? Why?
2. Compare regression 5 with regression 4. Which one of these models would you recommend that Lee use? Why?
3. Lee estimates the following data for the Baltimore store for next year: dollar value of merchandise purchased, $ 77,000,000; number of purchase orders, 4,200; number of suppliers, 120. How much should Lee budget for purchasing department costs for the Baltimore store for next year?
4. What difficulties do not arise in simple regression analysis that may arise in multiple regression analysis? Is there evidence of such difficulties in either of the multiple regressions presented in this problem? Explain.
5. Give two examples of decisions in which the regression results reported here (and in Problem 10-42) could beinformative.

Transcribed Image Text:

Regression 4: PDC = a + (b x No. of POs) + (b2 x No. of Ss) Variable Constant Independent variable 1: No. of POs Independent variable 2: No. of Ss Coefficient Standard Error -Value $481,186 $ 121.37 $259,020 $ 58.04 1458 1.86 2.09 2.02 2,941 063, Durbin-Watson statistic 1.91 Regression 5: PDC = a + (b × No. of POs) + (b2 x No. of Ss) + (by x MPD Variable Constant Independent variable 1: No. of POs Independent variable 2: No. of Ss Independent variable 3: MPS Coefficient Standard Error $311,137 S 63.79 S 1,646 Value 1.60 1.92 1.82 $496,544 $ 122.73 2996 -0.00002 -0.0030 0.63; Durbin-Watson statistic 1.92 PDC 0.28 No. of POs 065 0.63 MPS No. of POs MPS 0.27 0.35 No. of Ss 0.30