The National Football League (NFL) is arguably the most successful professional sports league in the United States. Following the recent season, the commissioner's office staff performed an analysis in which a simple linear regression model was developed with average home attendance used as the dependent variable and the total number of games won during the season as the independent variable. The staff was interested in determining whether games won could be used as a predictor for average attendance. Develop the simple linear regression model. The data are in the file calledNFL.

1.What percentage of total variation in average home attendance is explained by knowing the number of games the team won?

2.What is the standard error of the estimate for this regression model?

3.Using alpha = 0.05, test to determine whether the regression slope coefficient is significantly different from 0.

4.After examining the regression analysis results, what should the NFL staff conclude about how the average attendance is related to the number of games the team won?

A B C D E F G H 1 TEAM GMS TOTAL AVG PCT Wins Points Scored Points Allowed 311 387 2 Arizona 7 297,568 42,509 57.8 3 Atlanta 565,106 70,638 99.2 351 341 299 Baltimore 563,076 70,384 102.1 6 265 Buffalo 575,248 71,906 89.9 5 271 367 6 Carolina 587,700 73,462 100.3 11 391 259 Chicago 8 496,965 62,120 92.8 11 260 202 8 Cincinnati 526,469 65,808 100.4 11 421 350 578,330 100.4 6 232 301 9 Cleveland 72,291 10 Dallas 8 505,258 63,157 95.9 9 325 08 11 Denver 608,790 76,098 100 13 395 258 492,580 94.7 UT 345 12 Detroit 61,572 254 298 344 3 Green Bay 562,419 70,302 115.6 4 14 Houston 562,397 70,299 101.2 2 260 431 457,373 57,171 94.9 247 15 Indianapolis 14 439 16 Jacksonville 525,519 65,689 89 12 361 269 7 Kansas City 623,325 77,915 98.1 10 403 325 O0 00 00 00 18 Miami 575,256 71,907 95.6 9 318 317 Minnesota 511,960 63,995 99.9 9 306 344 20 New England 550,048 68,756 101.1 10 379 338 21 New Orleans 417,270 52,158 65.4 3 235 398 0 00 00 22 NY Giants 628,519 78,564 99.8 11 422 314 23 NY Jets 619,958 77,494 98.4 4 240 355 24 Oakland 418,450 52,306 83 4 290 383 5 Philadelphia 541,393 67,674 102.5 6 310 88 00 00 00 00 26 Pittsburgh 507,434 63,429 97.6 11 389 258 27 San Diego 529,916 66,239 92.9 418 312 523,426 65,428 93.2 4 239 428 San Francisco 532,954 66,619 99.4 13 271 29 Seattle 452 429 30 St. Louis 523,685 65,460 100.2 6 363 O0 00 00 00 274 31 Tampa Bay 521,741 65,217 99.3 11 300 32 Tennessee 553,192 69,149 103.2 4 299 421 33 Washington 716,999 89,624 111.9 10 359 293 34