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.
Can use the minitab. Part a) Develop a simple linear regression that compares wins to yards made (please show me the scatter plot) . 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
EXCEL DATA TO USE.
Team | Win | Rush | Pass | Yds Allowed | Yds Made |
Arizona Cardinals | 62.50 | 93.40 | 251.00 | 346.40 | 344.40 |
Atlanta Falcons | 56.30 | 117.21 | 223.19 | 348.90 | 340.40 |
Baltimore Ravens | 56.30 | 137.51 | 213.69 | 305.00 | 351.20 |
Buffalo Bills | 37.50 | 116.71 | 157.19 | 340.60 | 273.90 |
Carolina Panthers | 50.00 | 156.16 | 174.94 | 315.80 | 331.10 |
Chicago Bears | 43.80 | 93.24 | 217.06 | 337.80 | 310.30 |
Cincinnati Bengals | 62.50 | 128.48 | 180.63 | 301.40 | 309.10 |
Cleveland Browns | 31.30 | 130.45 | 129.75 | 389.30 | 260.20 |
Dallas Cowboys | 68.80 | 131.46 | 267.94 | 315.90 | 399.40 |
Denver Broncos | 50.00 | 114.71 | 226.69 | 315.00 | 341.40 |
Detroit Lions | 12.50 | 101.00 | 198.00 | 392.10 | 299.00 |
Green Bay Packers | 68.80 | 117.85 | 261.25 | 284.40 | 379.10 |
Houston Texans | 56.30 | 92.23 | 290.88 | 324.90 | 383.10 |
Indianapolis Colts | 87.50 | 80.91 | 282.19 | 339.20 | 363.10 |
Jacksonville Jaguars | 53.80 | 126.85 | 209.75 | 352.30 | 336.60 |
Kansas City Chiefs | 25.00 | 120.58 | 182.63 | 388.20 | 303.20 |
Miami Dolphins | 43.80 | 139.48 | 198.13 | 349.30 | 337.60 |
Minnesota Vikings | 75.00 | 119.85 | 259.75 | 305.50 | 379.60 |
New England Patriots | 62.50 | 120.05 | 277.25 | 320.20 | 397.30 |
New Orleans Saints | 81.30 | 131.61 | 272.19 | 357.80 | 403.80 |
New York Giants | 50.00 | 114.81 | 251.19 | 324.90 | 366.00 |
New York Jets | 56.30 | 172.25 | 148.75 | 252.30 | 321.00 |
Oakland Raiders | 31.30 | 106.29 | 159.81 | 361.90 | 266.10 |
Philadelphia Eagles | 68.80 | 102.34 | 255.56 | 321.10 | 357.90 |
Pittsburgh Steelers | 56.30 | 112.05 | 259.25 | 305.30 | 371.30 |
Saint Louis Rams | 6.30 | 111.50 | 167.88 | 327.00 | 279.38 |
San Diego Chargers | 81.30 | 88.94 | 271.13 | 326.40 | 360.06 |
San Francisco 49ers | 50.00 | 100.00 | 190.75 | 356.40 | 290.75 |
Seattle Seahawks | 31.30 | 97.86 | 218.94 | 372.80 | 316.80 |
Tampa Bay Buccaneers | 18.80 | 101.69 | 185.81 | 365.60 | 287.50 |
Tennessee Titans | 50.00 | 161.96 | 189.44 | 365.60 | 351.40 |
Washington Redskins | 25.00 | 94.38 | 218.13 | 319.70 | 312.50 |
Suppose you are a rabid football fan and you get into a discussion about the importance of offens...
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...
The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the data in the Excel Online file below show the conference (Conf), average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (Win96) for a random sample of 16 NFL teams for a season. Construct a spreadsheet to...
The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the following data show the conference (Conf), average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (win96) for a random sample of 16 NFL teams for a season Conf NFC NFC NFC AFC NFC NFC AFC AFC...
The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the following data show the conference (Conf), average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (Win96) for a random sample of 16 NFL teams for a season Conf NFC NFC NFC AFC NFC NFC AFC AFC...
The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the data in the Excel Online file below show the conference (Conf), average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (Win96) for a random sample of 16 NFL teams for a season. Construct a spreadsheet to...
The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won following data show the conference (Conf), average number (Win%) for a random sample of 16 NFL teams for a season Team Conf Yds/Att Int/Att Win% Arizona Cardinals NFC 6.7 0.043...
The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the data in the Excel Online file below show the conference (Conf), average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (Win%) for a random sample of 16 NFL teams for a season. Construct a spreadsheet to...
The National Football League (NFL) records a variety of performance data for individuals and teams. ail Sprint Wi-Fi 9:52 PM 18% Access WebAssign My Notes Previous Answers DATAfile: NFLPassing A statistical program is recommended The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the following data show the conference (Conf), average number of passing yards per attempt (Yds/Att), the...
After reading these instructions delete all text in this shaded area. B C D E F G HI J Conf Yds Atin At Win% Part a. 66 0043 501 After reading these instructens delete all text in this shaded area. K XLMiner Analysis ToolPak * Team 2 Arona Cardinals NFC Anova: Single Factor Carolina Panthers NFC Anova: Two-Factor With Replication 73 60 0.033 0.027 374 56.4 AFC Use the XL Miner Analysis ToolPak to conduct Your Linear regression and After...
The excel file National Football League provides various data on professional football for one season. Construct a scatter diagram for Points/Game and Yards/Game in the Excel file. Does there appear to be a linear relationship? Develop a regression model for predicting Points/Game as a function of Yards/Game. Explain the statistical significance of the model. Draw conclusions about the validity of the regression analysis assumptions from the residual plot and standard residuals. National Football League Data 2007 Season Team Points/Game Yards/Game...