please answer full question

2. Consider the following data for two abstract variables, x and y. Column i is an ID variable. Use Microsoft Excel's Data Amalysis Tool Pak to calculate the descriptive statistics for both variables. (a) What is the mean of x ? (b) What is the mean of y ? Use Microsoft Excel's Data Amalysis Tool Pak to fit a regression equation using y as the dependent variable. (c) What is 1 ? (d) What is 0 ? (e) What is r2 ? (f) What is SST? (g) What is SSE? (b) What is SSR? (i) What is MSE? (j) At what confidence level (not significant, 90%,95%, or 99% ) is 1 statistically significant? (k) At what confidence level (not signi ficant, 90%,95%, or 99% ) is 0 statistically significant? (I) What is the correlation coefficient for these 2 variables? (m) Does your model pass the F-test for the whole regression? Perform a residual analysis for your regression. Specifically, create 2 scatterplots. The first should have x as the borizontal axis and the residuals (errors) as the vertical axis. The second should have x as the horizontal axis and the standardiyed residuals (errors) as the vertical axis. Round wour 2 residual columus to 4 decimal nlaces Perform a residual amalysis for your regression. Specifically, create 2 scatterplots. The first should have x as the borizontal axis and the residuals (errors) as the vertical axis. The second should have x as the horizontal axis and the standardized residuals (errors) as the vertical axis. Round your 2 residual columrs to 4 decimal places (n) Did your regression pass the residual analysis (Yes or No)? Test your data for outliers. [Hint: There is one outlier.] (o) Which observation (which i ) was the outlier? Re-estimate the regression without the outlier. (p) What is 1 now? (q) What is 0 now? (r) What is r2 now? (s) At what confidence level (not significant, 90%,95%, or 99% ) is 1 statistically significant now? (t) At what confidence level (not significant, 90%,95%, or 99% ) is 0 statistically significant now? (u) What is the correlation coefficient for these 2 variables now? (v) Does your new model pass the F-test for the whole regression