From the course: Excel Statistics Essential Training: 1
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Permutations - Microsoft Excel Tutorial
From the course: Excel Statistics Essential Training: 1
Permutations
- [Instructor] What are the chances of rolling a six-sided die and getting a four? There's only one single four on the die and there are six sides, so you have a one-in-six chance. But what's the probability of choosing a queen from a standard deck of 52 cards? In this case, there's four queens in the deck and the deck has 52 cards. So if you pick only one card at random from the full deck, your chances are four divided by 52, 7.7%. This was easy. We knew there were four winning cards, four queens, and we knew that there were 52 cards in the deck. But sometimes when you're trying to calculate probability in the real world, things are a little bit more complex. For example, suppose we have a group of 10 people in a race. The three fastest runners, first, second, and third place, they'll each get a prize. How many different possible first, second, and third place combinations are there if we have 10 runners? Actually, 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.