Consider the following set of dependent and independent variables. Complete part
ID: 3367758 • Letter: C
Question
Consider the following set of dependent and independent variables. Complete parts a through e below y 46 43 41 39 31 2722 8 10 x1 75 64 78 53 43 47 3416 16 x2 22 29 20 17 12 16 7 16 10 a. Use technology to identify the SST, SSR, and SSE SST-1239 56 (Round to two decimal places as needed) SSR 1137.83 (Round to two decimal places as needed) SSE 101.73 (Round to two decimal places as needed) b. Calculate the multiple coefficient of determination R2 0.918 (Round to three decimal places as needed.) C. Test the significance of the overall regression model using ?:010 What are the null and alternative hypotheses for this test? A. Ho: ?,-?2 (No relationship between the vanables) H4: ß1 # ß2 (Relationship exists between the variables) Ho p, # ß2 (Relationship exists between the variables) H P B2(No relationship between the variables) B. ?. ?? p, ß2-0 (No relationship between the variables) HI: At least one B # 0 (Relationship exists between the variables)Explanation / Answer
applying multiple regression on a bove data:
d)
p value =0.001
Regression Statistics Multiple R 0.9581 R Square 0.9179 Adjusted R Square 0.8906 Standard Error 4.1176 Observations 9.0000 ANOVA df SS MS F Significance F Regression 2.0000 1137.8293 568.9146 33.5556 0.0006 Residual 6.0000 101.7263 16.9544 Total 8.0000 1239.5556 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 3.6551 3.9466 0.9261 0.3901 -6.0018 13.3120 -6.0018 13.3120 x1 0.4390 0.0880 4.9893 0.0025 0.2237 0.6543 0.2237 0.6543 x2 0.3832 0.3030 1.2650 0.2528 -0.3581 1.1245 -0.3581 1.1245