From the course: Excel Statistics Essential Training: 1

Unlock the full course today

Join today to access over 23,800 courses taught by industry experts.

Combinations

Combinations - Microsoft Excel Tutorial

From the course: Excel Statistics Essential Training: 1

Start my 1-month free trial Buy for my team

Combinations

“

- [Instructor] In a race, knowing who comes in first, second, and third is important but sometimes, the order of things is not as important. For example, Maria and Carlos drove together to their book club meeting. In total, 10 book club members came to this meeting. The book club will raffle off three $50 gift cards to three of the members in attendance. What is the probability both Maria and Carlos will win a gift card? To solve this, we'll need to understand how to calculate combinations. Please note, combinations are different than permutations. How? Well, look at these two lists of winners. James, Javier, Layla. Javier, Layla, James. In both cases, we have the same combination of winners. When we're giving away three gift cards, each $50 in value, the order in which we list the names? It doesn't impact the prize any one winner gets. So, both lists actually represent the same combination of winners. Now that we…

Contents