Difference between revisions of "Documentation/How Tos/Calc: MULTINOMIAL function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m (Robot: Automated text replacement %s)
Line 21: Line 21:
 
{{Documentation/SeeAlso|
 
{{Documentation/SeeAlso|
 
* [[Documentation/How_Tos/Calc: FACT function|FACT]]
 
* [[Documentation/How_Tos/Calc: FACT function|FACT]]
* [[Documentation/How_Tos/Calc: PRODUCT function|PRODUCT]]'''
+
* [[Documentation/How_Tos/Calc: PRODUCT function|PRODUCT]]
  
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]'''
+
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
  
* [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]'''
+
* [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]
  
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]

Revision as of 14:27, 26 February 2009


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.

Template:Documentation/SeeAlso

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.

Personal tools