Using the data in the Excel file Student Grades, apply the Excel Regression tool using the midterm grade as the independent variable and the final exam grade as the dependent variable.
a. Interpret all key regression results, hypothesis tests, and confidence intervals in the output.
b. Analyze the residuals to determine if the assumptions underlying the regression analysis are valid.
c. Use the standard residuals to determine if any possible outliers exist.