[Today is a two-post day at Football Perspective. Check here for my week 2 power rankings, while Neil provides an innovative look at the biggest comebacks of the last 35 years in this post. — Chase
In my last post, I introduced a method of estimating the home team’s pre-game win probability in Excel using the Vegas spread:
p(W) = (1-NORMDIST(0.5,-(home_line),13.86,TRUE)) + 0.5*(NORMDIST(0.5,-(home_line),13.86,TRUE)-NORMDIST(-0.5,-(home_line),13.86,TRUE))
The Comeback ranks as the 2nd most impressive comeback after two quarters, but only 20th overall.
Let me explain the rationale behind the scary-looking equation. The first part represents the probability that the home team ends regulation time with a lead of 1 point or more, using Hal Stern’s
finding that the home team’s final margin of victory can be approximated by a normal random variable with a mean of the Vegas line and a standard deviation of 13.86. The second part is the probability that regulation ends in a tie, multiplied by 0.5 (this assumes each team has roughly a 50-50 chance of winning in overtime).
With a small twist, we can also apply this formula within games, to the line-score data for every quarter. Within a game, the home team’s probability becomes:
p(W) = (1-NORMDIST(away_margin+0.5,-home_line*(minleft/60),13.86/SQRT(60/minleft),TRUE))+0.5*(NORMDIST(away_margin+0.5,-home_line*(minleft/60),13.86/SQRT(60/minleft),TRUE)-NORMDIST(away_margin-0.5,-home_line*(minleft/60),13.86/SQRT(60/minleft),TRUE))
This is the same equation as before, but we’re adding in Home_Margin (home team pts minus road team pts for the game, through the end of the quarter in question), reducing the effect of the home Vegas line linearly based on how much time remains in the game, and changing the standard deviation of scoring margin to become:
Stdev = 13.86 / sqrt(60 / n)
where n = the number of minutes remaining in the game.
These changes will help us estimate a team’s chances of winning at the end of each quarter. For instance, Monday night’s game — where the Falcons were a 3-point home favorite over the Broncos — goes from:
Team | 1st | 2nd | 3rd | 4th | Total |
Atlanta | 10 | 10 | 7 | 0 | 27 |
Denver | 0 | 7 | 0 | 14 | 21 |
To this:
Team | Pregame | After 1st | At Half | After 3rd | Final |
Atlanta | 58.6% | 84.6% | 93.0% | 99.9% | 100.0% |
Denver | 41.4% | 15.4% | 7.0% | 0.1% | 0.0% |
[continue reading…]