Excel - FiveThirtyEight Baseball Predictions for Cleveland - Episode 2057

3,047 views · Published 29 October 2016 · 8:17 · Indexed 14 November 2026

Channel: MrExcel.com · 2016 · Education

Watch on YouTube

Microsoft Excel Tutorial: Will Cubs or Tribe Win According to FiveThirtyEight?

Welcome to another episode of the MrExcel Podcast, where we dive into all things Excel. In this episode, we're going to take a break from our usual Excel tips and tricks and talk about something a little different - baseball. As a Cleveland Indians fan, I've been following the World Series closely and spending a lot of time on my favorite website, FiveThirtyEight, run by Nate Silver. While the site is known for its election coverage, Nate is actually a baseball guy first and has some amazing statistics that I live and breathe by.

Right now, Nate is predicting that the Indians have a 63% chance of winning the World Series, while the Cubs have a 37% chance. But these numbers fluctuate after every game, and using advanced modeling and the Elo statistic, Nate predicts the outcome of each game. As a fan, I wanted to understand how these predictions were made, so I turned to my trusty tool - Microsoft Excel.

Using some basic formulas and the RAN function, I was able to create a model that simulates the outcome of the remaining games in the series. And after running it 10,000 times, I found that my model was pretty close to Nate's predictions. But why stop at 10,000? With the help of Professor Simon Banega's data table trick, I was able to run the model 150,000 times and get a more accurate picture of the potential outcomes.

But what if something changes in the series? What if the Indians win or lose tonight's game? Well, with my model set up, it's easy to see the impact of that change. If the Indians win, their chances of winning the series increase to 85%, but if they lose, their chances drop to 43%. And for all you Cubs fans out there, a win tonight would give your team a 56% chance of winning the series.

To visualize these probabilities, I tried using the new treemap feature in Excel, but it didn't quite capture the data in the way I wanted. Luckily, my friend Jon Peltier, creator of the Marimekko Chart Utility, stepped in and created some amazing charts that show the impact of tonight's game on the series. So a big thank you to Jon for his help and for creating such a useful tool for Excel users.

So there you have it, a little break from our usual Excel content to talk about the exciting World Series and how Excel can be used to understand and predict the outcome. And as a Cleveland Indians fan, I'm hoping my team can pull off a win tonight and increase their chances of winning the series. But no matter what happens, it's been an exciting and historic series for both teams. Go tribe!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

#ExcelModeling
#WorldSeriesPredictions
#BaseballAnalytics
#ExcelSportsAnalysis
#DataModeling
#SportsPredictions
#ExcelDataScience
#WorldSeriesSimulation
#ExcelStatistics
#SportsDataAnalysis
#DataModelingTools
#ExcelBaseballAnalysis
#PredictingChampions

This video answers these common search terms:
world series prediction excel model
excel modeling for baseball outcomes
analyzing world series with excel
forecasting world series results in excel
statistical modeling for baseball in excel
predicting world series winners with excel
excel data analysis for sports outcomes
baseball playoff modeling in excel
simulating world series in microsoft excel
using excel for sports analytics

Table of Contents:
(00:00) 538 Predictions for Cubs/Tribe World Series
(01:04) Using Excel to understand Nate's predictions
(01:18) Examining the statistics and outcomes for the World Series
(03:00) Running the model 10,000 times and comparing results to Nate's predictions
(04:09) Using a data table to run the model 15 times
(05:19) Impact of Game 4 on the World Series outcome
(06:31) Shifting probabilities based on Game 4 results
(07:00) Using a treemap to visualize the data
(08:06) Jon Peltier's chart utility and its usefulness in creating charts in Excel.

Ever since I saw Nate "Moneyball" Silver present at a Microsoft conference, I've been a junkie for his election statistics at http://fivethirtyeight.com/. But Nate has baseball predictions, and as a long-suffering Cleveland Indians fan, I live and die by Nate's predictions for Cleveland winning the world series. But his model swings wildly after each game, first saying the Cubs would win, then the Tribe, then the Cubs, and now the Tribe. How can this be? Today, I use an Excel spreadsheet to play the World Series 150,000 times and come incredibly close to Nate Silver's conclusion. Thanks to Excel MVP Jon Peltier for his awesome chart utilities at: http://mrx.cl/2dJIYFO

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153883/

More from this channel