Consider the following set of dependent and independent variables. Complete part
ID: 3367657 • Letter: C
Question
Consider the following set of dependent and independent variables. Complete parts a through e below y 46 43 4139 3127 22 18 10 x1 75 64 78 53 43 47 34 16 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. R20.918 (Round to three decimal places as needed.) C. Test the significance of the overall regression model using ?:0.10 What are the null and alternative hypotheses for this test? A. Ho: B1 2 (No relationship between the variables) H4: ß1 # ß2 (Relationship exists between the variables) Ho: ß1 # ß2 (Relationship exists between the variables) H 1: ?,-?2 (No relationship between the variables) Ho ?,-?2-0 (No relationship between the variables) Ha At least one ßit 0 (Relationship exists between the variables) B. C.Explanation / Answer
applying regression on above:
a)
SST =1239.56
SSR =1137.83
SSE =101.73
b)
R2 =SSR/SST =0.918
c)
option C is crrect
F =33.55 ( please try 33.56 if this comes wrong)
critical score =Falpha =3.46
Regression Statistics Multiple R 0.958088 R Square 0.917933 Adjusted R Square 0.890578 Standard Error 4.11757 Observations 9 ANOVA df SS MS F Significance F Regression 2 1137.829 568.9146 33.55562 0.000553 Residual 6 101.7263 16.95438 Total 8 1239.556 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 90.0% Upper 90.0% Intercept 3.6551 3.9466 0.9261 0.3901 -6.0018 13.3120 -4.0138 11.3240 x1 0.4390 0.0880 4.9893 0.0025 0.2237 0.6543 0.2680 0.6099 x2 0.3832 0.3030 1.2650 0.2528 -0.3581 1.1245 -0.2055 0.9719