Syntax. MULTINOMIAL(number1,number2,...)
Definition. This function returns the polynomial coefficient of a set of numbers. The formula for the MULTINOMIAL() function is:
Arguments
number1 (required) and number2 (required) The minimum number of values is 1, and the maximum is 255 (29 in Excel 2003 and earlier versions) for which you want the multinomial
Background. The MULTINOMIAL() function calculates the polynomial coefficient for a set of numbers to determine the permutation (the order of identical elements).
With this function, you can also calculate the polynomial distribution.
Example. Assume that you want to calculate the number of alternative orders in which five people can sit on a bench with five seats. There are two women (a=2), two men (b=2), and one child (c=1). You use the following formula:
=MULTINOMIAL(2,2,1)
returns 30
. This means that there are 30 different possibilities.
3.138.69.163