Least squares Method team the following data show the confer

Least squares Method 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 website, February 12, 2012). 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. Develop the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt. 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. The average number of passing yards per attempt for the Kansas City Chiefs 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 Chiefs. Compare your prediction to the actual percentage of games won by the Kansas City Chiefs.

Solution

a.The estimated regression equation for predicting the percentage of wins given the avg no. of passing yards per attempt-

win = - 58.8 + 16.4 yds

b.The estimated regression equation for predicting the percentage of wins given the avg no. of interceptions thrown per attempt-

win = 97.5 - 1600 int

c.The estimated regression equation for predicting the percentage of wins given the avg no. of passing yards per attempt and avg no. of interceptions thrown per attempt-

win = - 5.8 + 12.9 yds - 1084 int

d.Wining percentage of Kansas City Chiefs=-5.8+12.9*6.2-0.036*1084=35.156

Actual percentage of wins=7/16=43.75

Thus the predicted winning percentage is a few less than the actual due to residual terms.