The Madness Has Begun

Day 1 Recap of the Tournament

The Madness Has Begun

As many of you are aware, the NCAA Men’s College Basketball tournament kicked off yesterday. My team and I crunched the numbers before the tournament using both the Sagarin and Pomeroy methods for predicting the winners for each match-up.

We built the 2018 College Basketball Championship app using Qlik Sense to help folks build and share their brackets. I thought it would be interesting to see just how accurate our predictions were after the first day of madness.

How we crunch the data:

For each match-up we allow users to view both the Chance of Victory and the expected Margin of Victory.

Chance of victory -Pomeroy Methodolgy

This method was developed by Ken Pomeroy. At a high level, this methodology predicts the likelihood of Team1 winning versus Team2. Higher calculated percentages indicate a stronger the prediction.

We came out of the gate on fire, predicting 13/16 games (81%)

Here are some examples of the Chance of Victory calculation in action on Day 1.

#8 Seton Hall vs #9 North Carolina State

#7 Rhode Island vs #10 Oklahoma


Of the 3 losses, the Chance of victory calculation had a slight lean in two of the games and the Arizona vs Buffalo game was a bracket-buster for a lot of folks.

#6 Miami (FL) vs #11 Loyola-Chicago

#8 Virginia Tech vs #9 Alabama


#4 Arizona vs #13 Buffalo


Margin of Victory – Sagarin Methodology

The method was developed by Jeff Sagarin. Using the Overall Rating for each team, we simply compare the ratings of the two teams in the match-up to predict the winner. The Overall Rating is blend of three different methods each of which is score-based.

If you need to know by how much a team is expected to win (I am talking to you folks in Las Vegas) to cash instead of rip up your tickets, the data predictions netted and 8-5-1 (62%) for the day. For the record, there were 2 games were the Vegas line matched our prediction, so we had no side.

Here are some examples of the Chance of Victory calculation in action.

Villanova won by 26

Michigan won by 14

Kansas won by 16

In the spirit of augmented intelligence, I used both the predictions from the app and my gut feeling (I’ll never learn) to pick my bracket. If you haven’t already done so, feel free to fill out your own bracket (we won’t tell anyone that you predicted the Buffalo vs Arizona upset after the fact)!





Chuck Bannon gives a Day 1 Recap of the #MarchMadness Tournament using #QlikSense data!

 

In this article:

Comments

Learn more about how Qlik can help your business.

Follow Qlik