A very simple regression from excel results: ProblemX Y 1.5 3.75 1 2 .25 1 .5 1.75 Regression Statistics OutputMultiple R .952728874 R Square .907692308 Adjusted R Square .861538462 Standard Error .433012702 Observations 4 Anova Df SS MS F Significnace F Regression 1 3.6875 3.6875 19.6667 .047271126 Residual 2 .375 .1875 Total 3 4.0625 Coefficients Standard error t stat p value Intercept .5 .42561023 1.174783792 .361012912 X 2 .450987617 4.434711565 .047271126 Residual output Observation Predicted Y Residuals 1 3.5 .25 2 2.5 -.5 3 1 0 4 1.5 .25 A) write out the estimated regression equation showing how Yhat depends on x. use the form normally presented in the textbook, using appropriate number values for b0 and b1 B) If X+1.6 what is the predicted value of Y (simple regression problem)? C) As seen in the computer input, there are only four data points listed in order: No.1=(1.5,3.75), No.2=(1,2), No.3=(.35,1) and No.4=(.5,1.75). Which data point lies exactly on the regression line Yhat vs X? hint... no calculations necessary for this answer. D) What is the % variation in y explained by the regression? E) Test the null hypothesis that the slope =0, with the alternative that slope is not=0 and using alpha=.05 . Write down the test (observed) t value and its p-value and state your conclusion about the hypothesis. Use numbers from the output (needs no calculation)