in %), the average number of yards gained, and the average number of yards allowed during a recent nfl season. team win yards gained yards allowed arizona cardinals 62.50 344.40 346.40 atlanta falcons 56.30 340.40 348.90 baltimore ravens 56.30 351.20 305.00 buffalo bills 37.50 273.90 340.60 carolina panthers 50.00 331.10 315.80 chicago bears 43.80 310.30 337.80 cincinnati bengals 62.50 309.10 301.40 cleveland browns 31.30 260.20 389.30 dallas cowboys 68.80 399.40 315.90 denver broncos 50.00 341.40 315.00 detroit lions 12.50 299.00 392.10 green bay packers 68.80 379.10 284.40 houston texans 56.30 383.10 324.90 indianapolis colts 87.50 363.10 339.20 jacksonville jaguars 53.80 336.60 352.30 kansas city chiefs 25.00 303.20 388.20 miami dolphins 43.80 337.60 349.30 minnesota vikings 75.00 379.60 305.50 new england patriots 62.50 397.30 320.20 new orleans saints 81.30 403.80 357.80 new york giants 50.00 366.00 324.90 new york jets 56.30 321.00 252.30 oakland raiders 31.30 266.10 361.90 philadelphia eagles 68.80 357.90 321.10 pittsburgh steelers 56.30 371.30 305.30 saint louis rams 6.30 279.38 327.00 san diego chargers 81.30 360.06 326.40 san francisco 49ers 50.00 290.75 356.40 seattle seahawks 31.30 316.80 372.80 tampa bay buccaneers 18.80 287.50 365.60 tennessee titans 50.00 351.40 365.60 washington redskins 25.00 312.50 319.70 click here for the excel data file a-1. estimate two simple linear regression models, where model 1 predicts the winning percentage based on yards gained and model 2 uses yards allowed. (negative values should be indicated by a minus sign. round your answers to 4 decimal places.) a-2. compare the two simple linear regression models. b-1. estimate a multiple linear regression model, model 3, that applies both yards gained and yards allowed to forecast winning percentage. (negative values should be indicated by a minus sign
