Calculate the multinomial coefficient for a list of numbers
=MULTINOMIAL(number1, [number2], ...)| Parameter | Description |
|---|---|
number1 |
The first value. |
number2 |
[optional] Additional values. |
The formula below calculates the multinomial coefficient for the numbers 3, 6, and 1:
=MULTINOMIAL(3, 6, 1) // returns 840This is equivalent to:
=FACT(3+6+1)/(FACT(3)*FACT(6)*FACT(1))Suppose you have a bag containing 2 red marbles and 2 blue marbles. You draw all 4 marbles one by one and place them in order. We can use the MULTINOM
=MULTINOMIAL(2, 2) // returns 6We can use the MULTINOMIAL function to count the number of distinct ways to distribute the 9 people into groups of 2, 3, and 4. The formula is:
=MULTINOMIAL(2, 3, 4) // returns 1260To start, let's calculate the probability of just one specific way to assign people to flavors: for example, the first two people pick chocolate, the
=(0.5^2) * (0.35^3) * (0.15^4) // 7.75195E-06This value is quite small, because it only accounts for one possible way the outcome could occur. In reality, there are 1260 different ways to assign
=MULTINOMIAL(2,3,4) * (0.5^2) * (0.35^3) * (0.15^4) // 0.006837223