From the course: Complete Guide to Excel Statistics with Copilot
Unlock this course with a free trial
Join today to access over 24,400 courses taught by industry experts.
Combinations
From the course: Complete Guide to Excel Statistics with Copilot
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 understand what a combination is, here is the formula used to find the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
Probability explained9m 9s
-
(Locked)
Percentiles11m 16s
-
(Locked)
Permutations6m 56s
-
(Locked)
Combinations6m 24s
-
(Locked)
Addition rule of probability7m 58s
-
(Locked)
Multiplication rule of probability4m 43s
-
(Locked)
Conditional probability and probability trees7m 56s
-
(Locked)
Copilot: Probability12m 39s
-
(Locked)
-
-
-
-
-
-
-
-
-
-