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 (Cont), 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 spreadshort to answer the following questions. X THUTH Open spreadsheet a. Develop the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt (to I decimal) Win% = +by. Yds/Att by = b 1 decimal Develop the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt to Win% = 6 + by Int/Att b = b = c. Develop 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 to 1 decimal) Win% + b Yds/Att + b Int/Att b. Develop the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt to 1 decimal), Win% = bo +bInt/Att bo = bi c. Develop 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 to 1 decimal). Win% bo + by. Yds/Att + by - Int/Att b = bi b = d. The average number of passing yards per attempt for the Kansas City Chiets was 6.2 and the number of interceptions thrown per attempt was 0.036. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the Kansas City Chiefs (Note: For this season the Kansas City Chiefs record was 7 wins and 9 fosses.) Compare your prediction to the actual percentage of games won by the Kansas City Chiefs (to whole number), Predicted percentage Actual percentage A 1 Team 2 Arizona Cardinals 3 Atlanta Falcons 4 Carolina Panthers 5 Cincinnati Bengals 6 Detroit Lions 7 Green Bay Packers 8 Houstan Texans 9 Indianapolis Colts 10 Jacksonville Jaguars 11. Minnesota Vikings 12 New England Patriots 13 New Orleans Saints 14 Oakland Raiders 15 San Francisco 49ers 16 Tennessee Titans 17 Washington Redskins 118 B Conf NFC NFC NFC AFC NFC NFC AFC AFC AFC NFC AFC NFC AFC NFC AFC NFC C Yds/Att 6.4 7.1 7.5 6.3 7.0 8.9 7.3 5.6 4.7 5.6 8.2 7.9 7.5 6.3 6.7 6.5 D Int/Att 0.043 0.021 0.033 0.027 0.023 0.013 0.019 0.027 0.032 0.033 0.020 0.020 0.043 0.010 0.024 0.042 E Win% 49.7 62.6 37.2 56.3 62.6 93.5 62.6 12.5 31.2 18.7 81.1 81.4 50.0 81.4 56.0 31.3 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 (Cont), 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 spreadshort to answer the following questions. X THUTH Open spreadsheet a. Develop the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt (to I decimal) Win% = +by. Yds/Att by = b 1 decimal Develop the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt to Win% = 6 + by Int/Att b = b = c. Develop 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 to 1 decimal) Win% + b Yds/Att + b Int/Att b. Develop the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt to 1 decimal), Win% = bo +bInt/Att bo = bi c. Develop 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 to 1 decimal). Win% bo + by. Yds/Att + by - Int/Att b = bi b = d. The average number of passing yards per attempt for the Kansas City Chiets was 6.2 and the number of interceptions thrown per attempt was 0.036. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the Kansas City Chiefs (Note: For this season the Kansas City Chiefs record was 7 wins and 9 fosses.) Compare your prediction to the actual percentage of games won by the Kansas City Chiefs (to whole number), Predicted percentage Actual percentage A 1 Team 2 Arizona Cardinals 3 Atlanta Falcons 4 Carolina Panthers 5 Cincinnati Bengals 6 Detroit Lions 7 Green Bay Packers 8 Houstan Texans 9 Indianapolis Colts 10 Jacksonville Jaguars 11. Minnesota Vikings 12 New England Patriots 13 New Orleans Saints 14 Oakland Raiders 15 San Francisco 49ers 16 Tennessee Titans 17 Washington Redskins 118 B Conf NFC NFC NFC AFC NFC NFC AFC AFC AFC NFC AFC NFC AFC NFC AFC NFC C Yds/Att 6.4 7.1 7.5 6.3 7.0 8.9 7.3 5.6 4.7 5.6 8.2 7.9 7.5 6.3 6.7 6.5 D Int/Att 0.043 0.021 0.033 0.027 0.023 0.013 0.019 0.027 0.032 0.033 0.020 0.020 0.043 0.010 0.024 0.042 E Win% 49.7 62.6 37.2 56.3 62.6 93.5 62.6 12.5 31.2 18.7 81.1 81.4 50.0 81.4 56.0 31.3
