The Excel file National Football League provides various data on professional football for the 2007 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. Develop a regression model for predicting Points/ Game as a function of Yards/Game. Explain the statistical significance of the model. c. Draw conclusions about the validity of the regression analysis assumptions from the residual plot and standard residuals. d. Find a 95% confidence interval for the mean number of Points/Game for teams with 300 Yards/Game. e. Find a 95% prediction interval for a team having 300 Yards/Game.