Max Gooding is tired of losing money in his offices weekly football pool and has decided to

Max Gooding is tired of losing money in his office’s weekly football pool and has decided to try to do something about it. Figure (and file Fig.xls on your data disk) contains a listing of the teams in the Imaginary Football League (IFL) along with the outcomes of all the games played in the league last season. For instance, cell F5 indicates the Minnesota Raiders beat the Atlanta Eagles by two points last year, whereas cell F6 indicates Atlanta beat the Los Angeles Pirates by three points. Max believes it may be possible to use the Evolutionary algorithm in Solver to estimate the margin of victory in a matchup between any two teams. Using last season’s data, Max wants to identify ratings or weights for each team such that the estimated margin of victory for any match-up would be:

With this information, Max could estimate the margin of victory in a matchup between any two teams. He wants to do this in a way that minimizes the sum of the squared differences between the actual and estimated margins of victory for each of the games last year. (Assume each team’s rating should be between 0 and 100 and the home field advantage should be between 0 and 20.)
a. Create a Solver model that achieves Max’s objective.
b. If Max used this model to predict the winner in each of last year’s games, how many times would he have picked the winning team correctly?
c. Suppose Max wants to maximize the chance of picking the winning teams. Resolve the problem to achieve this objective.
d. If Max used your model from part c to predict the winner in each of last year’s games, how many times would he have picked the winning teamcorrectly?

Transcribed Image Text:

Fig8-44.ls [Compatibility Mode)- Microsoft Excal Home Insert Page Layout FormulasDats Review View Add-ins Imaginary Football League Visiting Home Margin of Home Team 4 Team No. Team Name Chicego Grizzles 14 Cleveland Reds Dalas Cowpokes Detrot Leoperds Croan Bay Pickera 0 Houaton Creiaora hdianapoia Ponka Kanaaa City Idiana LoR Angaea Piratea 18 14 LoB Angele8 Goste Wismi Tarpons Wisneeots Raiders 17 New England Volumeer 8 New Oreans Sinners New York Midgets 20New York Rockets Phladelphis H 23 Ptsburgh Robbers 28 24 San Dego Checiers 2San Frandsco 39ers 31 27 Tamps Bay Raidere 32 Wsahington Pigekiha Ready