Good Day excelers... how do I calculate a Permutations list from my range i.e. 0-3 (list above), please see sheet to understand.
Good Day excelers... how do I calculate a Permutations list from my range i.e. 0-3 (list above), please see sheet to understand.
Last edited by QuantEdge; 09-16-2017 at 08:55 AM.
Hi QuantEdge,
I don't understand your question. Normally a Permutations problem looks like this:
If I have 6 people and I want to make all possible pairs of them, how many would I have. The answer would be Permut(6,2) or 30. That means there are 30 different ways to group 6 people in groups of 2. The order of the people (who is first person and the second person) doesn't matter. IE Joe and Bob is the same as Bob and Joe.
In your problem you have 0-3 which I assume is how many ways can you group 0 people taken 3 at a time. This brings up an error.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
0-3 is the range i.e. 0,1,2,3 I updated the sheet to also shown the "Numbers in each permut" (in yellow columns).
I have added a updated sheet to clear explain each part and the total Permutations from the numbers left. which is 280799719200000000000 (does that look right as its a very big number?)
Hey Quant,
Nope - your data still doesn't make sense to me. You need to give me two numbers for a permutation problem. The first is how many you are selecting and the second is from how many. The first number needs to be smaller than the second. When you have "0-3", I'm clueless on what this means.
Because permutations have a Factorial in them, they grow very fast, so your number being VERY big is no surprise to me.
See this site to understand more - http://www.icoachmath.com/math_dicti...rmutation.html
I will add a simple example:
I have two groups of numbers 0-3 (4 numbers total).
thus how many permuts from (0-3) & (0-3) =
16 permuts right (see below) so how can I calculate this in excel, should I just use A1*B1 (4 in A1 & 4 in B1).
0,0
0,1
0,2
0,3
1,0
1,1
1,2
1,3
2,0
2,1
2,2
2,3
3,0
3,1
3,2
3,3
OK - I'm getting closer to understanding the problem now.
Permutations are where the ORDER matters. So if I would say how many permutations are there for digits 0 to 3, taken 2 at a time, I'd get the list you show above!! In teaching this in school there was the "With Repeats" problem. Can you use a number twice or not? In your example you are using 0,0 and 1,1 which would not be allowed. So the Permutations of 4 things taken 2 at a time is Permut(4,2)=12 (4 choices for the first number and 3 for the second as repeats are not allowed).
What you are showing above is another Excel Function called PermutationA(4,2) which does allow for repitions or 4*4 = 16
https://www.youtube.com/watch?v=KwIHas6Q3Uo
https://www.thoughtco.com/combinatio...ations-3126548
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks