Whether you’re a manager or an analyst, if you’ve ever had to work with data, chances are you’re no stranger to spreadsheets. Much of the data we interact with is stored in spreadsheets, with their ubiquity justified by the versatility and portability of tools such as Microsoft Excel, or Google Sheets. But often times, spreadsheets present data in a report format, which is conducive to reading, but not to analysis. For example, a company’s financial statements might contain a report that looks like this:

This report is easy to read, but what if we wanted to analyze this revenue data…

Former NBA veteran and current ESPN analyst Kendrick Perkins stirred up controversy over the last week, proclaiming that winning the NBA Finals is more difficult than winning the NFL Super Bowl. Perkins’ logic, that winning 16 games is harder than winning 3 or 4, drew the ire of erstwhile NFL lineman Jeff Saturday, who emphasized the narrow margin of error that NFL teams face in a win-or-go-home format. As the two former athletes went back and forth in their qualitative debate, I couldn’t help but wonder whether or not we could recast the conversation with a statistical framing.

It turns…

Wally Castelaz

Analyst by day, metal screamer by night. Except on days when the reverse is true.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store