Question

In: Statistics and Probability

The National Football League (NFL) records a variety of performance data for individuals and teams. 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 (Win%) for a random sample of 16 NFL teams for the 2011 season (NFL web site, February 12, 2012).

Click on the datafile logo to reference the data.

Team Conference Yds/Att Int/Att Win%
Arizona Cardinals NFC 6.5 0.042 50.0
Atlanta Falcons NFC 7.1 0.022 62.5
Carolina Panthers NFC 7.4 0.033 37.5
Cincinnati Bengals AFC 6.2 0.026 56.3
Detroit Lions NFC 7.2 0.024 62.5
Green Bay Packers NFC 8.9 0.014 93.8
Houstan Texans AFC 7.5 0.019 62.5
Indianapolis Colts AFC 5.6 0.026 12.5
Jacksonville Jaguars AFC 4.6 0.032 31.3
Minnesota Vikings NFC 5.8 0.033 18.8
New England Patriots AFC 8.3 0.020 81.3
New Orleans Saints NFC 8.1 0.021 81.3
Oakland Raiders AFC 7.6 0.044 50.0
San Francisco 49ers NFC 6.5 0.011 81.3
Tennessee Titans AFC 6.7 0.024 56.3
Washington Redskins NFC 6.4 0.041 31.3

Let x1 represent Yds/Att.
Let x2 represent Int/Att.

The average number of passing yards per attempt for the Pittsburgh Steelers during the 2011 season was 8, and the team’s number of interceptions thrown per attempt was 0.028. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the Pittsburgh Steelers during the 2011 season. (Note: For the 2011 the 2011 season, the Pittsburgh Steelers' record was 7 wins and 9 loses.)

If required, round your answer to one decimal digit. Do not round intermediate calculations. 67.5%(correct)

Compare your prediction to the actual percentage of games won by the Pittsburgh Steelers. If required, round your answer to one decimal digit.

Q. The Pittsburgh Steelers performed worse than what we predicted by ? %.

Solutions

Expert Solution

result

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.867461188
R Square 0.752488913
Adjusted R Square 0.714410284
Standard Error 12.60236794
Observations 16
ANOVA
df SS MS F Significance F
Regression 2 6277.014191 3138.507096 19.76144986 0.000114384
Residual 13 2064.655809 158.8196776
Total 15 8341.67
Coefficients Standard Error t Stat P-value Lower 95%
Intercept -5.763283816 27.1467994 -0.212300674 0.835165005 -64.41037837
Yds/Att 12.94935632 3.185669555 4.064877446 0.001338458 6.067135667
Int/Att -1083.787956 357.1165398 -3.034829909 0.009575422 -1855.291335

y^= -5.7633 + 12.9494 yds/att -1083.787956* int/Att

= -5.7633 + 12.9494 *8 -1083.787956* 0.028

= 67.4858

= 67.5 %

7 wins and 9 loses

hence actual % = 7/(7+9) *100 % = 43.75%

hence worse by 67.5 - 43.8%

= 23.7 %


Related Solutions

The National Football League (NFL) records a variety of performance data for individuals and teams. 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 (Win%) for a random sample of 16 NFL teams for the 2011 season (NFL web site, February 12, 2012) Team Conference...
The National Football League (NFL) records a variety of performance data for individuals and teams. 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 (Win%) for a random sample of 16 NFL teams for a season Team Conf Yds/Att Int/Att Win% Arizona Cardinals NFC 6.7...
The National Football League (NFL) records a variety of performance data for individuals and teams. 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 (Win%) for a random sample of 16 NFL teams for one full season. Team Conf Yds/Att Int/Att Win% Arizona Cardinals NFC...
The National Football League (NFL) records a variety of performance data for individuals and teams. 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 (Win%) for a random sample of 16 NFL teams for a season. Team Conf Yds/Att Int/Att Win% Arizona Cardinals NFC 6.7...
The National Football League (NFL) records a variety of performance data for individuals and teams. 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 average number of passing yards per attempt (Yards/Attempt) and the percentage of games won (WinPct) for a random sample of 10 NFL teams for the 2011 season.† Team Yards/Attempt WinPct Arizona Cardinals 6.5 50 Atlanta Falcons 7.1 63 Carolina Panthers 7.4 38 Chicago Bears 6.4...
The National Football League (NFL) records a variety of performance data for individuals and teams. 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 (Win%) for a random sample of  NFL teams for a season Team Conf Yds/Att Int/Att Win% Arizona Cardinals NFC 6.7 0.043 50.0...
The National Football League (NFL) records a variety of performance data for individuals and teams. 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 (Win%) for a random sample of 16 NFL teams for a season... Team Conf Yds/Att Int/Att Win% Arizona Cardinals NFC 6.4...
The National Football League (NFL) records a variety of performance data for individuals and teams. 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 average number of passing yards per attempt (Yards/Attempt) and the percentage of games won (WinPct) for a random sample of 10 NFL teams for the 2011 season.† Team Yards/Attempt WinPct Arizona Cardinals 6.5 50 Atlanta Falcons 7.1 63 Carolina Panthers 7.4 38 Chicago Bears 6.4...
The National Football League (NFL) records a variety of performance data for individuals and teams. 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 average number of passing yards per attempt (Yards/Attempt) and the percentage of games won (WinPct) for a random sample of 10 NFL teams for the 2011 season.† Team Yards/Attempt WinPct Arizona Cardinals 6.5 50 Atlanta Falcons 7.1 63 Carolina Panthers 7.4 38 Chicago Bears 6.4...
The National Football League (NFL) records a variety of performance data for individuals and teams. 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 average number of passing yards per attempt (Yds/Att) and the percentage of games won (Win%) for a random sample of  NFL teams. Team Yds/Att Win% Team 1 6.5 43 Team 2 7.9 76 Team 3 8.0 74 Team 4 7.6 63 Team 5 7.3 66 Team...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT