From the course: Learning Excel: Data Analysis

Unlock the full course today

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

Calculate permutations with duplication

Calculate permutations with duplication - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Calculate permutations with duplication

“

- [Presenter] In the previous movie, I described how to work with permutations. That is sets where the order of values matters without duplication. In this movie, I will show you how to calculate the number of possible permutations when duplication is allowed. As before, let's assume that we have eight speakers who are available to speak at a company event, and we want to choose three. However, it is possible that we can have the same person go twice. So in other words, duplication is allowed. I do want to emphasize that order still matters. So having the same person go first and third is considered a different permutation than having a person go first and second. So once again, order still matters. So our question here is how do we calculate the number of unique orders that are possible when choosing three of eight people when repetition is allowed? To demonstrate the process, I will switch over to our Excel sample…

Contents