MULTINOMIAL |
MULTINOMIAL(number1 [,number2] [..]) |
Returns the number of permutations for a given number of items (with duplicates). |
number1 | The first number. |
number2 | (Optional) The second number. |
REMARKS |
* This is called the Multinomial Coefficient. * There is no Excel function for a multinomial distribution. * The multinomial coefficient is an extension of the Binomial Coefficient. * The multinomial coefficient is used to find the "correct" number of permutations when you have duplicate values. * The multinomial is the ratio of the factorial of a sum of values to the product of the factorials. * If any argument is less than one, then #NUM! is returned. * If any argument is not numeric, then #VALUE! is returned. * You can have a maximum of 255 arguments. * You can use the COMBIN function to return the number of combinations for a given number of items (without repetition). * You can use the FACT function to return the factorial of a positive whole number. * link - statisticshowto.com/multinomial-coefficient * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top