Question

Team Win% Arizona Cardinals Int/Att 0.042 0.022 50.0 Atlanta Falcons 62.5 Conf Yds/Att NFC 6.5 NFC 7.1 NFC AFC NFC 7.2 Carolina Panthers 0.033 37.5 Cincinnati Bengals 56.3 0.026 0.024 Detroit Lions 62.5 Green Bay Packers 0.014 93.8 Houstan Texans AFC 0.019 62.5 Indianapolis Colts AFC 12.5 Jacksonville Jaguars AFC 0.026 0.032 0.033 31.3 Minnesota Vikings 18.8 New England Patriots 81.3 NFC AFC NFC AFC New Orleans Saints 81.3 0.020 0.021 0.044 0.011 Oakland Raiders 7.6 50.0 San Francisco 49ers NFC 81.3 Tennessee Titans AFC 6.7 0.024 56.3 Washington Redskins NFC 0.041 31.3 (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. (Round your numerical values to one decimal place. Let x, represent Yds/Att and y represent Win%) y = (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. (Round your numerical values to the nearest integer. Let x, represent Int/Att, and y represent Win%.) (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. (Round your numerical values to the nearest integer. Let x, represent Yds/Att, x, represent Int/Att, and y represent Win%) (d) The average number of passing yards per attempt for a certain team was 6.3 and the number of interceptions thrown per attempt was 0.034. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the team. (Round your answer to one decimal place.) For this season the team's record was 7 wins and 9 losses. Compare your prediction to the actual percentage of games won by the team. The predicted value is lower than the actual value. The predicted value is higher than the actual value. The predicted value is identical to the actual value.

Answer 1

Answer: y = -58.7 + 16.4**ds/Att > Â = 94.5 -1600.5* Int /Abt _ s ĝ = -5.8 +12.9 * YDS / Att -1083.8*Int /Att dy > Yds / Att = 6.3 & Int/Abt = 0.034 ... t = -5.8 tl2.4 (< 3) – 1983.8 (0.03%) = 38.6% actual value = 77.7 7. The predicted value is lower than the actual valde

Outputs from Ms-excel