The file P07_28.xlsx lists the scores of all NFL games played during the 2008 season. Use this data set to rank the NFL teams from best to worst.
Carry out the suggestion in Modeling Issue 3. That is, find the ratings of the 2009 NFL teams using the sum of absolute prediction errors as the criterion to minimize. Discuss any differences in ratings from this method and the method used in Example 7.8.
EXAMPLE 7.8 RATING NFL TEAMS9
We obtained the results of the 256 regular-season NFL games from the 2009 season and entered the data into a spreadsheet, shown at the bottom of Figure 7.33 (see the file NFL Ratings.xlsx). (Some of these results are hidden in Figure 7.33 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 25 Pittsburgh versus team 31 Tennessee, played at Pittsburgh. Pittsburgh won the game by a score of 13 to 10, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.
Objective To use NLP to find the ratings that best predict the actual point spreads observed.
WHERE DO THE NUMBERS COME FROM? Sports fans thank heaven for the Web. The results of NFL games, as well as NBA, MLB, and other sporting games, can be found on a number of Web sites. We got this data from http://www.pro-football-reference.com/years/2009/games.htm. To see much more about sports ratings, go to Jeff Sagarin’s page at http://www.usatoday.com/sports/sagarin.htm. Of course, if you are an avid sports fan, you probably already know the good Web sites.