7. (13 points) In a simple regression where Y is the dependent variable and X is the independent variable (both are continuous variables) suppose the sums of squares error (residual) is 1127.169 and the total sums of squares is 1283.189. The sample size is 111. a. (8 points 1 point for each value) Fill in the values in the following ANOVA Table (use excel to compute the exact p-value of the F-test) ANOVA TABLE mm m RESIDUAL TOTAL b. (1 point) Compute and interpret the R2 c. (1 point) Compute the interpret the standardized coefficient. d. (1 point) Compute the t-test for the regression coefficient. 15 it significant? e. (1 point) Suppose the regression estimate (slope) is 0.143. Compute a 95 % confidence interval for the regression estimate. Does the 95% CI include zero? f. (1 point) What do you conclude about the association of X and Y