Please post excel

For this SLR question, students can work in Excel directly using the basic Excel functions. Please provide all the details for each question. Failure to do so will result in loss of marks. The following data set gives the number of icebergs sighted monthly south of Newfoundland, x, and south of the Grand Banks, y for 1920: X 3 10 36 83 130 68 25 13 9 4 3 2 0 4 9 18 13 3 2 1 0 0 0 a. Assume Y= a + B*X + 6. Estimate the simple linear regression line. (3 points) b. What is the residual for the case (68, 13)? (3 points) c. Test Ho: =0. Draw a conclusion whether the regression coefficient is significantly different from 0 or not, at 95% significance level. (MSE = 2.053) (3 points) d. Determine the coefficients of stermination. Based on this, do you think this model is a good fit or not. (3 points) e. Construct a 95% confidence interval for the mean number of icebergs seen at the Grand Banks if there are 50 seen south of Newfoundland. (3 points)