Excitement Index and Comeback Factor

Over the last couple of weeks, John has occasionally put up a FanShot with a Win Probability graph from Advanced NFL Stats. As cool as those charts are, Advanced NFL Stats has taken it to another level. Using the WP numbers already in place, they have created Excitment Index and Comeback Factor scores for every game since 2000. Maybe you should have a seat and take some deep breaths.This is just way too cool to take standing up.

The comeback index was easy. For any given game, the 'CBF' is based on the lowest win probability at any point for the ultimate winner. To make bigger comebacks have bigger CBFs, I made CBF be the inverse of the lowest WP.

For example, if a team is down by 10 with 10 minutes left in the 4th quarter, they'd have around a 0.13 WP. This means the trailing team has a 1 in 8 chance of winning, and the CBF is therefore 8. A team that comes back from a 0.01 WP, would have a CBF of 100, the largest possible.

That's a logical way to measure the magnitude of a comeback,  but how would one measure the excitement of an NFL game?

EI is simply the sum of the WP graph's movement throughout a game. That's it. Despite the simplicity, this method captures much of what makes a game interesting. Games with large swings in WP will end up with large EIs, while blow-out games where the WP quickly climbs to 0.95 for one team will have smaller EIs.

What are the top 5 most exciting Seahawks games since 2000? J.T. O'Sullivan is a jerk.

Game ID Visitor Home Date Excitement
28698 NYG 21 SEA 24 11/27/2005 8.8
27108 SEA 27 MIN 23 12/12/2004 7.3
29188 SEA 24 CHI 27 1/14/2007 7.0
29378 SEA 28 PHI 24 12/2/2007 6.7
29552 SF 33 SEA 30 9/14/2008 6.7
X
Log In Sign Up

forgot?
Log In Sign Up

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior users will need to choose a permanent username, along with a new password.

Your username will be used to login to SB Nation going forward.

I already have a Vox Media account!

Verify Vox Media account

Please login to your Vox Media account. This account will be linked to your previously existing Eater account.

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior MT authors will need to choose a new username and password.

Your username will be used to login to SB Nation going forward.

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

By becoming a registered user, you are also agreeing to our Terms and confirming that you have read our Privacy Policy.

Join Field Gulls

You must be a member of Field Gulls to participate.

We have our own Community Guidelines at Field Gulls. You should read them.

Join Field Gulls

You must be a member of Field Gulls to participate.

We have our own Community Guidelines at Field Gulls. You should read them.

Spinner.vc97ec6e

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9341_tracker