Question

s Question: 6 pts 3 of 17 (0 complete) This Test: 123 pts EQuestion He se the accompanying set of dependent and independent variables to complete parts a through c below Click the on to view tie data set. a) Using technology, construct a multiple regression model with the given data. Round to three decimal places as needed) b) Interpret the meaning of the values for by and b2 Select the correct choloe below and fil in the answer boxes within your choice Round to three decimal places as needed.) A. The value for b, means that when x2 is equal to O,x s equal to The vale for b means that when x equals 0,2 is equal to OB. The val efor b, means thatfor are itcharge in x, with x2 con stant, yī reases by■ Themafor b means that timeur tchange n O C. wit constant, y increases by The value for b, means that for a one-unt change in wih k constant, inceases bThe value for by means that for a one-untch in wh conistant, y increases by c)Provide an estirnate for y when x1 17 and x2-14. Set of dependent and independent variable oundeo y46 42 3033 25 23 17 21 | 28 | 19 | 17 14 18 8 14 10 ath T Click to select your answerls). Print Done 5 6 8

Answer 1

Solution-

(A) After running the regression analysis in the excel, regression output is-

SUMMARY OUTPUT Regression Statistics MultipleR R Square 0.94175455 0.886901632 Adjusted R Square 0.849202176 Standard Error4.846314177 Observations 9 ANOVA MS Significance F Regression Residual Total 2 1105.079433 552.539723.52558 0.001446668 140.9205666 23.48676 1246 Intercept X Variable 1 X Variable 2 Coefficients Standard Error tstat P-value Lower 95% U per 95% 2.451550125 5.004032402 0.489915 0.641591 -9.792876064 14.69597631 0.443283153 0.110599451 4.008005 0.007054 0.172656045 0.713910261 0.402577127 0.4112418930.97893 0.36542 0.603695534 1.408849788

Regression equation is-

Y = 2.4516 + 0.4433 X1 + 0.4026 X2

(B) Slope of X1 = 0.4433

Meaning of slope of X1 = change in the value of Y when X1 changes by 1 unit given that the value of X2 remains constant.

Slope of X2 = 0.4026

Meaning of slope of X2 = change in the value of Y when X2 changes by 1 unit given that the value of X1 remains constant.

(C) When X1 = 17 and X2 = 14

then Y = 2.4516 + 0.4433 * 17 + 0.4026 * 14

= 15.624

Answers

TY!