Suppose you are a rabid football fan and you get into a discussion about the importance of offense (yards made) versus defense (yards allowed) in terms of winning a game. You decide to look at football statistics to provide evidence of which variable is a stronger predictor of wins. Part a) Develop a simple linear regression that compares wins to yards made. Perform the following diagnostics on this regression: 1) test of significance on the slope; 2) assess the fit of the line using the appropriate statistics; 3) interpret the slope of the equation if the slope is significant. Part b) Develop a simple linear regression that compares wins against yards allowed. Perform the following diagnostics on this regression: 1) test of significance on the slope; 2) assess the fit of the line using the appropriate statistics; 3) interpret the slope of the equation if the slope is significant. Part c) Which explanatory variable provides a better prediction of the response variable? Support your answer briefly by citing the appropriate diagnostics. Note: Use an alpha of .05 for both tests of significance. Be sure to show ALL steps of the hypothesis testing procedure. There is the same data (Excel style):TeamWinRushPassYds AllowedYds MadeArizona Cardinals62.5093.40251.00346.40344.40Atlanta Falcons56.30117.21223.19348.90340.40Baltimore Ravens56.30137.51213.69305.00351.20Buffalo Bills37.50116.71157.19340.60273.90Carolina Panthers50.00156.16174.94315.80331.10Chicago Bears43.8093.24217.06337.80310.30Cincinnati Bengals62.50128.48180.63301.40309.10Cleveland Browns31.30130.45129.75389.30260.20Dallas Cowboys68.80131.46267.94315.90399.40Denver Broncos50.00114.71226.69315.00341.40Detroit Lions12.50101.00198.00392.10299.00Green Bay Packers68.80117.85261.25284.40379.10Houston Texans56.3092.23290.88324.90383.10Indianapolis Colts87.5080.91282.19339.20363.10Jacksonville Jaguars53.80126.85209.75352.30336.60Kansas City Chiefs25.00120.58182.63388.20303.20Miami Dolphins43.80139.48198.13349.30337.60Minnesota Vikings75.00119.85259.75305.50379.60New England Patriots62.50120.05277.25320.20397.30New Orleans Saints81.30131.61272.19357.80403.80New York Giants50.00114.81251.19324.90366.00New York Jets56.30172.25148.75252.30321.00Oakland Raiders31.30106.29159.81361.90266.10Philadelphia Eagles68.80102.34255.56321.10357.90Pittsburgh Steelers56.30112.05259.25305.30371.30Saint Louis Rams6.30111.50167.88327.00279.38San Diego Chargers81.3088.94271.13326.40360.06