From the course: Learning Excel: Data Analysis

Unlock the full course today

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

Calculate permutations without duplication

Calculate permutations without duplication - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Calculate permutations without duplication

“

- [Instructor] When you analyze business data, you will often need to select a subset of a larger collection of items. When the order matters, you are dealing with what are called permutation. As an example, let's assume that you have eight individuals who have offered to speak at a company event but you can only choose three. If the order those individuals speak in matters then you're dealing with a permutation. And again, the order of these speakers matters. So instead of having one, two, three, if you have the speaker set up as two, three, one then you're dealing with a different permutation. And once again, order matters. One question you can ask about permutations without duplication is how many unique orders are possible when choosing three out of eight people with no repeats? I'll switch over to Excel and show you how to set up this type of problem in your workbook. I've switched over to Excel and I have opened the sample file for this movie. That is 06_04 Permutations Without…

Contents