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 answer the following questions. TEAM
Conf.
YDS/ATT
Int/Att
Win%
Cardinals
NFC
6.5
.042
50.0
Flacons
NFC
7.1
.022
62.5
Panthers
NFC
7.4
.033
37.5
Bengals
AFC
6.2
.026
56.3
Lions
NFC
7.2
.024
62.5
Packers
NFC
8.9
.014
93.8
Texans
AFC
7.5
.019
62.5
Colts
AFC
5.6
.026
12.5
Jaguars
AFC
4.6
.032
31.3
Vikings
NFC
5.8
.033
18.8
Patriots
AFC
8.3
.020
81.3
Saints
NFC
8.1
.021
81.3
Raiders
AFC
7.6
.044
50.0
49ers
NFC
6.5
.011
81.3
Titans
AFC
6.7
.024
56.3
Redskins
NFC
6.4
.041
31.3
A) Develope the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt.
B) Develope the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt.
C) Develope the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt and the number of interceptions thrown per attempt.
D) The average number of passing yards per attempt for the Kansas City Cheifs was 6.2 and the number of interceptions thrown per attempt was .036. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the kansas City Cheifs. (Note: For the 2011 season teh Kansas City Cheifs' record was 7 wins and 9 losses.) Compare your predictions to the actual percentage of games won by the Kansas City Chiefs.