Question 3 17 pts Download the data on NFL wins 2011 here 3|; . If that does not work, t_ry here. u? Be sure to copy all the data. There should be 33 rows. The data set includes the average number of passing yards obtained per game on offense (OffPassYds/G), the average number of yards given up per game on defense (Dedes/G), and the percentage of games won (Win%), for one full season. Let's develop an estimated regression equation that can be used to predict the percentage of games won given the average number of passing yards obtained per game on offense and the average number of yards given up per game on defense. %wz'ns(y) 2 g -| ,31 OffPassYds / G + g DefY ds / G -| e Note all values have been rounded to four decimal places Use Excel to generate the estimated model and answer the questions below Estimated%wins(3)) 2 be + (31 OffPassYds / G -| [31 DefY ds / G a. What is the multiple coefficient of determination, R2? [ Select] V b. The adjusted multiple coefficient of determination, adjusted R2, is equal to 1 - ((1 R2)* [Select] v c. What is the value for the mean square due to error (MSE)? [ Select] V d. The value for the F-test for overall significance is [ Select ] e. We [ Select ] the null hypothesis that B1 = 32 = 0 at level of 5% significance f. The value of the intercept term is [ Select ] g. The coefficient on OffPass Yds/G is [ Select ] h. The coefficient on DefYds/G is [ Select ] i. Which coefficients are significant at the 5% significance level, a = 0.05? [ Select ] j. Which coefficients are significant at the 1% significance level, a = 0.01? [ Select ] k. What is the lower bound of the 95% confidence interval for the coefficient on OffPassYds/G [ Select ] I. What is the upper bound of the 95% confidence interval for the coefficient on OffPassYds/G [ Select ]m. What is the predicted % win for a team that has a value of average passing yards obtained per game on offense (OffPassYds/G) of 200 and average number of yards given up per game on defense (Dedes/G) of 300 [Select] V