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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920