Excel - Leagues Cup Tie Probability / Will Messi Play in Orlando in August - Episode 2610

Описание: Microsoft Excel Tutorial: Tiebreakers in Leagues Cup Soccer Group Stage.

Lionel Messi's debut in the US for Miami is in the Leagues Cup. This four-week tournament includes 47 clubs from across the USA, Canada, and Mexico. What are the odds of a tiebreaker in group play for the Leagues Cup? If Miami finishes first or second in their group, who will they play in the knockout stage?

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

Welcome to another episode of Excel with Bill Jelen! In this video, we will be discussing the upcoming Leagues Cup tie and the probability of seeing the legendary Lionel Messi play in Orlando this August. As always, we will be using Excel to analyze the data and make predictions.

The Leagues Cup is a relatively new soccer tournament that features teams from Major League Soccer (MLS) and Liga MX, the top professional leagues in the United States and Mexico, respectively. In this episode, we will be looking at the upcoming match between Orlando City SC and Tigres UANL, two powerhouse teams in their respective leagues. Using Excel, we will analyze their past performances and current standings to determine the probability of each team winning the tie.

But the real question on everyone's mind is whether or not we will see Lionel Messi, one of the greatest soccer players of all time, play in Orlando this August. Rumors have been circulating that Messi may join Inter Miami CF, a new MLS team, and potentially play in the Leagues Cup. We will use Excel to analyze the likelihood of this happening and what it could mean for the tournament and the sport as a whole.

So join me as we dive into the world of soccer and Excel to predict the outcome of the Leagues Cup tie and the possibility of seeing Messi on the field in Orlando. Don't forget to like and subscribe to our channel for more Excel tips and sports analysis. Let's get started!

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-...



Table of Contents
(0:00) Problem Statement: Odds of tiebreaker
(0:21) Orlando City Soccer two home matches in Leagues Cup
(0:48) Lionel Messi's US debut will be in Leagues Cup
(1:00) Leagues Cup Overview
(1:26) Orlando City in South Group 2
(1:40) 2 Automatic Berths in knockout round
(2:00) Who would play Messi in Knockout round?
(2:22) Scenarios in Group Play
(2:57) Group Play Draw
(3:15) 64 Scenarios
(3:30) SEQUENCE in Excel
(3:45) BASE function in Excel
(4:15) SWITCH function in Excel
(4:37) Ranking with LARGE function in Excel
(4:50) CONCAT function in Excel
(5:00) Checking for Ties
(5:16) 25% chance of a tie in Leagues Cup Group Play
(6:22) Tiebreakers in Leagues Cup Group Play
(7:15) Six possible teams to play Messi in knockout round
(7:40) Wrap-up