Pick your Final Four with Math

· Tumblr ·

3 min read Original article ↗

Sadly, my Vols did not make the tournament this year. So the ol’ pick my favorite team to Win It ALL bracket is not an option. When prayers fail, however, I can always fall back on Math.

Here’s what I did:

  1. Pick a probability that each team will make it to a given round
  2. Multiply by the number of points you will get if they make it that far
  3. Maximize your expected point value

Pick a probability that each team will make it to a given round

This is really the hardest part of the equation. Sports bettors spend millions of dollars and thousands of hours figuring it out. Luckily, Nate Silver at 538 did all the hard work for us. Since I’m also a super nerd, and so are the guys at 538, I just navigated to their Github site, https://github.com/fivethirtyeight/data and forked the repository and renamed it 538data. From there, I cloned it to my local machine:

I then imported the tsv into Excel and created a new sheet.

Now the probabilities are ready for analysis.

Multiply by the number of points by the chances that the team will make it

Here are the rules for my bracket (note each one may be different):

Second Round: The weight for each correct pick is 1. The seed of the winning team is multiplied by the correct pick total.
Third Round: The weight for each correct pick is 2. The seed of the winning team is added to the correct pick total.
Sweet 16 ® : The weight for each correct pick is 4. The seed of the winning team is added to the correct pick total.
Elite 8 ® : The weight for each correct pick is 8. The seed of the winning team is added to the correct pick total.
Final Four ® : The weight for each correct pick is 16. There is no bonus applied.
Championship: The weight for each correct pick is 16. There is no bonus applied.

Of course, your rules may vary. In our bracket the seeds are only added after the “second round” and seeds don’t matter at all in Final Four picks. Many other brackets multiply seeds throughout.

After multiplying the points if the team won by the value if they win that game, I get the expected value of picking that team that team.

Your spreadsheet should now look something like this: 

image

Of course the yellow columns are the important ones to look at in the next section.

Maximize your expected point value

I then go through my bracket game by game and decide which team offers me the most points for that game. EG Cincinnati offers 4.30 points for the pick in the first round vs purdue’s 4.17, so the Bearcats are the best pick. If I pick Butler, I expect 2.73 points vs Texas’s 6.00 points, so Texas is the clear pick.

I then compare the next round and next round and so on.

Analysis of the bracket

From a basketball perspective, my picks couldn’t be more boring. I have only 1 and 2 seeds in the Elite 8, and Arizona is the only 2 seed to make the Final Four. This is hardly surprising given that the rules of the bracket do not give a big boost for picking a low seed to go deep into the tournament. In fact, chances are most of the points in the tournament are going to be scored in the early round rather than the later ones!

Want in on this?

I posted my spreadsheet on my github profile, and another copy into GoogleDrive. If you use it, I want to hear from you!