Difference between revisions of "Documentation/How Tos/Calc: MULTINOMIAL function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
| Line 5: | Line 5: | ||
This function is only available if '''Analysis AddIn''' is installed. | This function is only available if '''Analysis AddIn''' is installed. | ||
| − | |||
=== Syntax: === | === Syntax: === | ||
| Line 12: | Line 11: | ||
: This function returns: | : This function returns: | ||
:: <tt>'''( number1 + number2 + ... + number30 )! / (number1! * number2! * ...* number30!)'''</tt> | :: <tt>'''( number1 + number2 + ... + number30 )! / (number1! * number2! * ...* number30!)'''</tt> | ||
| − | |||
=== Example: === | === Example: === | ||
| Line 20: | Line 18: | ||
<tt>'''MULTINOMIAL(F1:F3)'''</tt> | <tt>'''MULTINOMIAL(F1:F3)'''</tt> | ||
: where F1 to F3 contain <tt>'''2'''</tt>, <tt>'''3'''</tt> and <tt>'''4'''</tt> returns <tt>'''1260'''</tt>. | : where F1 to F3 contain <tt>'''2'''</tt>, <tt>'''3'''</tt> and <tt>'''4'''</tt> returns <tt>'''1260'''</tt>. | ||
| − | |||
=== See also: === | === See also: === | ||
| Line 29: | Line 26: | ||
'''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | '''[[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | ||
| − | |||
=== Issues: === | === Issues: === | ||
The multinomial distribution is a generalization of the binomial distribution in probability theory. <tt>'''MULTINOMIAL()'''</tt> is currently categorised as a Mathematical function, but would be more readily categorised as a Statistical function. | The multinomial distribution is a generalization of the binomial distribution in probability theory. <tt>'''MULTINOMIAL()'''</tt> is currently categorised as a Mathematical function, but would be more readily categorised as a Statistical function. | ||
Revision as of 07:05, 2 March 2008
MULTINOMIAL
Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.
This function is only available if Analysis AddIn is installed.
Syntax:
MULTINOMIAL (number1; number2; ... number30)
- number1 to number30 are up to 30 numbers or ranges of numbers.
- This function returns:
- ( number1 + number2 + ... + number30 )! / (number1! * number2! * ...* number30!)
Example:
MULTINOMIAL(1; 2)
- returns 3, which is (1+2)!/(1!*2!).
MULTINOMIAL(F1:F3)
- where F1 to F3 contain 2, 3 and 4 returns 1260.
See also:
Issues:
The multinomial distribution is a generalization of the binomial distribution in probability theory. MULTINOMIAL() is currently categorised as a Mathematical function, but would be more readily categorised as a Statistical function.
