For the data set, complete parts (a) through (d) Data Set Click the icon to view
ID: 3318632 • Letter: F
Question
For the data set, complete parts (a) through (d) Data Set Click the icon to view the data se (a) Construct a correlation matrix bewoon x. x2. Xa, and y. Complete the table belovw. x1 244 018 582 x2 2.8 2.6 6.7 3.9 2.5 5.7 7.8 089 10.6 10.3 10.3 10.7 10.0 9.4 817 199 5.1 2.7 8.4 14.0 6.0 14.6 9.3 2.3 2.5 2.9 2.3 2.0 Round to three decimal places as needed.) 5.9 8.6 9.2 5.5 Is there any evidence that multicolinearity exists? Why? Choose the correct answer below. o A. Yes, because there is a high correlation between some of the explanatory variables. O B. Yes, because there is not a high correlation between any of the explanatory variables C. No, because tere is not a high correlation between any of the explanatory variables. 5.5 8.7 0 D. No, because tere is a high correlation between some of the explanatory vanables. (b) Determine the multiple regression line with x,2.and x3 as the explanatory variables. y=|7.530-080x1 + 1.209|x2 + L053 Print Done Round to three decimal places as needed.) c Assuming that the requirements of the model are satisfied test H0-A-p2- Calculate the P-vaue using technology 3-0 versus H1 : at least one of the is din rent f om zero at the 0.10 level of significance. Round to three decimal places as needed) State a conclusion for the test. Choosc the correct answer below. A. B. ° C. 0 D. Do not reject Ho There is not suffic ent evidence to conclude that at least one of the explanatory variables s linear y related to the response var able Do not reject Ho. There is sufficient evidence to conclude that at least one of the explanatory variables is linearly related to the response variable Reject h, There is sufficient evidence to conclude that at least one of the explanatory variables is linearly related to the response variable. Reject Hj. There is not sufficient evidence to conclude that at least one of the explanatory variables is linearly related to the response variable. Click to select your answers).Explanation / Answer
c) p-value = 0.00863
option C) is correct
d)
b1
p-value = 0.05294
option C) is correct
b2
p-value = 0.00597
option A) is correct
b3
p-value = 0.46444
option C) is correct
SUMMARY OUTPUT Regression Statistics Multiple R 0.915718257 R Square 0.838539926 Adjusted R Square 0.757809889 Standard Error 0.425278959 Observations 10 ANOVA df SS MS F Significance F Regression 3 5.635826842 1.878608947 10.38696322 0.008630714 Residual 6 1.085173158 0.180862193 Total 9 6.721 Coefficients Standard Error t Stat P-value Lower 95% Intercept 7.530451834 0.856025321 8.796996597 0.000119698 5.435833332 x1 -0.080135464 0.033322396 -2.404853005 0.052943693 -0.161672429 x2 1.209359598 0.290987309 4.156056166 0.005970602 0.497339304 x3 0.053156034 0.068053308 0.781094051 0.464441174 -0.113364411