Using the data in the Excel file Demographics, apply the Excel Regression tool using unemployment rate as the dependent variable and cost of living index as the independent 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.