Chapter 35. Using Solver to rate sports teams
Question answered in this chapter:
Can I use Excel to set NFL point spreads?
Many of us follow basketball, football, hockey, or baseball. Odds makers set point spreads on games in all these sports and others. For example, the bookmakers’ best guess was that the Carolina Panthers would win the 2016 Super Bowl by five points. Instead, the Denver Broncos won the game. In this chapter, we will learn how the Solver can accurately estimate the relative strength of NFL teams.
Using a simple Solver model, you can generate reasonable point spreads for games based on the scores of the 2015 season (including ...
Get Microsoft Excel 2016 Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
