Solved

Posted on 2009-02-09

Could you let me the possible combinations of the values in the atached sheet pl.?

factorial.xls

factorial.xls

7 Comments

AB, BC, AC. <---- 3 combinations

Also BA, CB, CA if the order is relevant. <--- 3 more combinations

Combinations of all of them (permutation):

ABC, ACB, BAC, BCA, CAB, CBA <--- factorial of 3

How about state 5?? There we have 6!

As it is not defined how many components there are in each combination, we can assume a permutation for each state and, as stated by ozo, just multiply the factorials:

3! x 3! x 4! x 3! x 6! x 2! x 2! x 1 x 1

Jose

We can combine numbers by adding, multiplying them or just puting them together, so in the representation AB, for instance, we can have a value A + value B, or value A x value B, and so on.

Another interpretation is "how many combinations are there if we use one cell of each column (state)?" For example: AFHKPUVXYZ is one of them. In this case, the combinations are calculated as stated before, just multiplying the number of cells of each state.

Jose

with or without alphabetical constraints, and with or without order being relevant,

that case would not be the same as multiplying the number of options for each state.

As per the question's title, would be about permutations, which uses factorials to calculate it, but I'm not sure of that.

Jose

By clicking you are agreeing to Experts Exchange's Terms of Use.

Title | # Comments | Views | Activity |
---|---|---|---|

Australian Method of paying off a mortgage | 6 | 345 | |

Help with Excel formulas | 8 | 62 | |

Algorithm for the classification of scores | 6 | 70 | |

Good Magazines technology related | 4 | 104 |

Join the community of 500,000 technology professionals and ask your questions.

Connect with top rated Experts

**11** Experts available now in Live!