Yardbarker
2024 NCAA Tournament Bracket: This data will help you win your pool  

Photo by Andy Hancock/NCAA Photos via Getty Images

Photo by Andy Hancock/NCAA Photos via Getty Images

Everybody loves March Madness, but let's be honest, who amongst us has been following all 363 teams and knows them inside and out? If you're seeking guidance on filling out your bracket and want to win your office pool or take your friends' money, you've come to the right place.

I always wondered how KenPom, the most trusted name in college basketball analytics and forecasting, determined his projected final scores on his FanMatch page.

Through a ton of Google searches — plus some trial and error — I was able to figure out the formula and project out a final score for any Division I college basketball game using each team’s efficiency and tempo numbers.

From there, I use a Pythagorean expectation formula to determine the probability of each team winning based on the projected final score. In the Excel sheet below, you'll be able to figure out each team’s win probability for every possible matchup all the way through the National Championship.

However, there are a couple of important notes that you need to read before using this to fill out your bracket:

  • Don't fill everything out based on who has the higher probability. If you’ve been a part of a March Madness pool before, you know that you have to take some chances by either taking a few first-round upsets or pick a dark horse to make the Elite Eight.
  • The theory behind win probability is “what is the most likely scenario.” Do not take these percentages as gospel. Instead, use them as a guide.
  • Injuries are accounted for in this model, using a version of John Hollinger’s value added formula that's been modified for college basketball.
  • If a player is designated as questionable, they're included in the win probability as if they're playing. I will update the Excel spreadsheet accordingly once the news of whether a player is playing or not is made official. 

Download the Excel file of the bracket with projections

More must-reads:

Sign up for the Bark Bets Newsletter

Bark Bets is Yardbarker's free daily guide to the world of sports betting. You'll get:

  • Picks and predictions from our in-house experts
  • The last-minute updates that give you an edge
  • Special offers from Sportsbooks

Subscribe now!

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.