Question

Use the accompanying set of dependent and independent variables to complete parts a through c below. Click the icon to view the data set. a) Using technology, construct a multiple regression model with the given data. ŷ= 0 + (x + 0x2 (Round to three decimal places as needed.) Set of dependent and independent variables 10 1 16 у X1 X2 12 5 16 5 16 8 11 22 6 1 26 10 9 30 17 7 350 21 11 13 Print Done

Answer 1

Answer:

$\hat{y}= 15.989+1.029x_1+(-0.501)x_2$

Excel output

to get excel output enter all data in Excel sheet

SUMMARY OUTPUT Regression Statistics Multiple R. 0.9616637 R Square 0.92479707 Adjusted R Square 0.89471589 Standard Error 2.88888311 Observations 8 ANOVA df 2 Regression Residual Total SS MS F Significance F 513.1467718 256.5734 30.74338 0.001550911 41.72822816 8.345646 554.875 5 7 Intercept x1 Coefficients Standard Error t Stat p-value Lower 95% Upper 95% 15.9894465 3.995174647 4.00219 0.010301 5.719523118 26.2593699 1.02912869 0.200933841 5.121729 0.003702 0.512611807 1.54564557 -0.50058287 0.276737576 -1.80887 0.130261 - 1.21195945 0.21079372 x2

Choose DATA > data analysis > regression

Y input : select y values

X input : select x1 and x2 values

Compute