Still In Hunt For MLS Supporters Shield As Of Sept 22 2023 Using Excel - Episode 2626 #mls

У вашего броузера проблема в совместимости с HTML5

Microsoft Excel Tutorial: Modeling the rest of the MLS Season 100,000 times.

Which teams are still in the hunt for the MLS Supporters Shield?

Update from September 25, 2023: Over the weekend, Cinci won their match. This leaves only Cinci, New England, Orlando City, and Philly in the hunt. Cinci’s percentage has improved to 99.292%. All that Cinci has to do to wrap up the Supporters Shield is win one match or draw one match and have New England and Philly draw or lose.

To download this workbook: https://www.mrexcel.com/youtube/1VLFg7VeW7M/

Welcome to episode 2626 of MrExcel’s netcast, where we tackle the burning question of who is still in the hunt for the MLS Supporters’ Shield as of September 22, 2023. In this video, we will use Excel to perform Monte Carlo analysis and simulate the remaining matches to determine the potential winners of the Shield.

As of September 23rd, 2023, Cincinnati has been the clear favorite for the Supporters’ Shield, with a 15-point lead since June or July. However, their recent winless streak in September has allowed other teams to close the gap. In this video, we will explore the possible outcomes if Cincinnati were to lose all remaining matches and determine which teams have a chance to surpass their current 59 points.

Using the RAND function in Excel, we will simulate the remaining matches and calculate the points gained by each team. We will also utilize the new VSTACK function to stack the home and away team points into a single array. Then, using the SUMIF function, we will determine the total points gained by each team and their final points tally.

Initially, I made a critical math error and calculated 39 matches left instead of 39 to the third power, which is an insanely large number. To overcome this, we will run the simulation 100,000 times using the SEQUENCE function and the data table feature in Excel. This will give us a better understanding of the possible outcomes and the percentage chance of each team winning the Supporters’ Shield.

In the end, Cincinnati still has a 96.7% chance of winning the Shield, but there is a 1.3% chance for Orlando City to overtake them and a 0.3% chance for Philadelphia to win outright. There are also some interesting scenarios where tiebreakers may come into play, such as the game between New England and Philly on Decision Day.

Even if your team is not currently in the running, there is still a chance for them to win the Supporters’ Shield. We could run this simulation another 100,000 times and have a completely different set of results. So, good luck to all the teams still in the hunt and thank you for watching this episode of MrExcel’s netcast. Don’t forget to Like, Subscribe, and Ring the Bell for more Excel tips and tricks. Feel free to leave any questions or comments down below. See you next time!

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/

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