Tag Archives: basketball

Pick up basketball: Should you shoot more 2 pointers or 3 pointers when you play winners’ take?

The NBA basketball season just started last week, and the three point shot is having its moment. Despite some high profile doubters, the Warriors are the reigning NBA champions due to very impressive three point shooting. Also, the total number of three pointers taken in the NBA has steadily risen over the past 35 years.

Is it better to take a three pointer or a two pointer? The theory behind this is pretty simple, and can be done without a spreadsheet. Because a three pointer is worth 50% more than a two pointer, if a team can hit three pointers with at least 2/3 the percentage that they hit two pointers, then they would be better off taking more three pointers. Continue reading


What would the Lakers’ record be if Kobe Bryant was an average shooting guard?

The Lakers are off to a rough start this year – through 9 games they are 1-8, good enough for last place in the Western Conference. In this spreadsheet problem solving example, we’ll use spreadsheets to answer a pertinent question – if the legendary Kobe Bryant played like an average shooting guard, how would the Lakers have fared this year? Continue reading

The Basketball Bank Shot – visualize it with spreadsheets!

Spreadsheets are at their best when they are helping us solve useful problems. And what could be more useful than getting better at basketball? Perhaps this spreadsheet could help you dominate avoid getting kicked out of your local pickup game..

Continue reading

How Analytics & Spreadsheets are changing the NBA

“‘Most teams are using spreadsheets or just using our reports,’ says Brian Kopp, executive vice-president at STATS. ‘The Raptors go a step beyond that, which only a few teams are doing, and their visualizations are the best I’ve seen.'”

This quote is taken from a piece describing how technology, statistics, and analytics are changing basketball.

Full article here.