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

Regression 4: PDC = a + (b1 * No. of POs) + (b2 * No. of Ss)

Regression 5: PDC = a + (b1 * No. of POs) + (b2 * No. of Ss) + (b3 * MP$)

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

Required
1. Evaluate regression 4 using the criteria of economic plausibility, goodness of fit, significance of independent variables, and specification analysis. Compare regression 4 with regressions 2 and 3 in Problem 10-47. Which one of these models would you recommend that Hart use? Why?
2. Compare regression 5 with regression 4. Which one of these models would you recommend that Hart use? Why?
3. Hart estimates the following data for the Baltimore store for next year: dollar value of merchandise purchased, $78,500,000; number of purchase orders, 4,100; number of suppliers, 110. How much should Hart 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-47) could be informative

Transcribed Image Text:

fficient Standard ErroValue $256,684 Variable Constant Independent variable 1: No. of POs Independent variable 2: No. of Ss $484,522 s 126.66 57.80 219 s 2,903 1.89 1,459 1.99 Variable S483,560 S 126.58 $ 2,901 Coefficient Standard Error t-Value 1.55 1.99 1.79 0.0029 0.01 $312,554 Constant Independent variable 1: No. of POs Independent variable 2: No. of Ss Independent variable 3: MPS 63.75 $ 1,622 0.00002 of Pos 028MP 0.27 PDC No. of POs No. of POs No. of Ss 0.66 0.62 0.30 0.22