Simple Linear Regression, Residual Analysis and Regression Assumptions

The Excel file National Football League provides various data on professional football for one season.

a. Construct a scatter diagram for points/game and yards/game in the Excel file. Does there appear to be a linear relationship?

b. Use the Regression tool to develop a model for predicting points/game as a function of yards/game. Explain the statistical significance of the model and R2value.

c. Analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any possible outliers exist.