Simple Linear Regression, Residual Analysis and Regression Assumptions

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

National Football League Data 2007 Season \begin{tabular}{|l|r|r|} \hline Team & Points/Gan & Yards/Gam \\ \hline Arizona Cardinals & 25.2 & 344.1 \\ \hline Atlanta Falcons & 16.2 & 301 \\ \hline Baltimore Ravens & 17.2 & 302 \\ \hline Buffalo Bills & 15.8 & 277.1 \\ \hline Carolina Panthers & 16.7 & 284.9 \\ \hline Chicago Bears & 20.9 & 293.2 \\ \hline Cincinnati Bengals & 23.8 & 348 \\ \hline Cleveland Browns & 25.1 & 351.3 \\ \hline Dallas Cowboys & 28.4 & 365.7 \\ \hline Denver Broncos & 20 & 346.3 \\ \hline Detroit Lions & 21.6 & 322.9 \\ \hline Green Bay Packers & 27.2 & 370.7 \\ \hline Houston Texans & 23.7 & 333.6 \\ \hline Indianapolis Colts & 28.1 & 358.7 \\ \hline Jacksonville Jaguars & 25.7 & 357.4 \\ \hline Kansas City Chiefs & 14.1 & 276.8 \\ \hline Miami Dolphins & 16.7 & 287.5 \\ \hline Minnesota Vikings & 22.8 & 336.2 \\ \hline New England Patriots & 36.8 & 411.2 \\ \hline New Orleans Saints & 23.7 & 361.2 \\ \hline New York Giants & 23.3 & 331.4 \\ \hline New York Jets & 16.8 & 294.7 \\ \hline Oakland Raiders & 17.7 & 294.8 \\ \hline Philadelphia Eagles & 21 & 358.1 \\ \hline Pittsburgh Steelers & 24.6 & 327.4 \\ \hline San Diego Chargers & 25.8 & 315.2 \\ \hline San Francisco 49ers & 13.7 & 237.3 \\ \hline Seattle Seahawks & 24.6 & 348.9 \\ \hline St. Louis Rams & 16.4 & 297.5 \\ \hline Tampa Bay Buccaneet & 20.9 & 326.8 \\ \hline Tennessee Titans & 18.8 & 311.7 \\ \hline Washington Redskins & 20.9 & 333.4 \\ \hline \end{tabular}