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

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
Line 1: Line 1:
−
{{Documentation/MasterTOC
+
{{DISPLAYTITLE:MULTINOMIAL function}}
−
|bookid=1234'''
+
{{Documentation/CalcFunc MathematicalTOC
−
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
+
|ShowPrevNext=block
−
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Mathematical_functions|<div style="font-size: 140%;">Mathematical Functions]]
+
|PrevPage=Documentation/How_Tos/Calc:_LCM_ADD_function
−
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_PRODUCT_function
+
|NextPage=Documentation/How_Tos/Calc:_PRODUCT_function
−
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_LCM_ADD_function
+
}}__NOTOC__
−
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Logical_functions
+
−
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Number_Conversion_functions
+
−
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Trigonometric</div>
+
−
* [[Documentation/How_Tos/Calc:_COS_function|<div style="font-size: 120%;">Cos]]
+
−
* [[Documentation/How_Tos/Calc:_SIN_function|<div style="font-size: 120%;">Sin]]
+
−
* [[Documentation/How_Tos/Calc:_TAN_function|<div style="font-size: 120%;">Tan]]
+
−
* [[Documentation/How_Tos/Calc:_COT_function|<div style="font-size: 120%;">Cot]]
+
−
* [[Documentation/How_Tos/Calc:_ACOS_function|<div style="font-size: 120%;">Acos]]
+
−
* [[Documentation/How_Tos/Calc:_ACOT_function|<div style="font-size: 120%;">Acot]]
+
−
* [[Documentation/How_Tos/Calc:_ASIN_function|<div style="font-size: 120%;">Asin]]
+
−
* [[Documentation/How_Tos/Calc:_ATAN_function|<div style="font-size: 120%;">Atan]]
+
−
* [[Documentation/How_Tos/Calc:_ATAN2_function|<div style="font-size: 120%;">Atan2]]
+
−
* [[Documentation/How_Tos/Calc:_DEGREES_function|<div style="font-size: 120%;">Degrees]]
+
−
* [[Documentation/How_Tos/Calc:_RADIANS_function|<div style="font-size: 120%;">Radians]]
+
−
* [[Documentation/How_Tos/Calc:_PI_function|<div style="font-size: 120%;">Pi]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Hyperbolic</div>
+
−
* [[Documentation/How_Tos/Calc:_COSH_function|<div style="font-size: 120%;">Cosh]]
+
−
* [[Documentation/How_Tos/Calc:_SINH_function|<div style="font-size: 120%;">Sinh]]
+
−
* [[Documentation/How_Tos/Calc:_TANH_function|<div style="font-size: 120%;">Tanh]]
+
−
* [[Documentation/How_Tos/Calc:_COTH_function|<div style="font-size: 120%;">Coth]]
+
−
* [[Documentation/How_Tos/Calc:_ACOSH_function|<div style="font-size: 120%;">Acosh]]
+
−
* [[Documentation/How_Tos/Calc:_ACOTH_function|<div style="font-size: 120%;">Acoth]]
+
−
* [[Documentation/How_Tos/Calc:_ASINH_function|<div style="font-size: 120%;">Asinh]]
+
−
* [[Documentation/How_Tos/Calc:_ATANH_function|<div style="font-size: 120%;">Atanh]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Rounding and remainders</div>
+
−
* [[Documentation/How_Tos/Calc:_TRUNC_function|<div style="font-size: 120%;">Trunc]]
+
−
* [[Documentation/How_Tos/Calc:_ROUND_function|<div style="font-size: 120%;">Round]]
+
−
* [[Documentation/How_Tos/Calc:_ROUNDDOWN_function|<div style="font-size: 120%;">Rounddown]]
+
−
* [[Documentation/How_Tos/Calc:_ROUNDUP_function|<div style="font-size: 120%;">Roundup]]
+
−
* [[Documentation/How_Tos/Calc:_CEILING_function|<div style="font-size: 120%;">Ceiling]]
+
−
* [[Documentation/How_Tos/Calc:_FLOOR_function|<div style="font-size: 120%;">Floor]]
+
−
* [[Documentation/How_Tos/Calc:_EVEN_function|<div style="font-size: 120%;">Even]]
+
−
* [[Documentation/How_Tos/Calc:_ODD_function|<div style="font-size: 120%;">Odd]]
+
−
* [[Documentation/How_Tos/Calc:_MROUND_function|<div style="font-size: 120%;">Mround]]
+
−
* [[Documentation/How_Tos/Calc:_INT_function|<div style="font-size: 120%;">Int]]
+
−
* [[Documentation/How_Tos/Calc:_QUOTIENT_function|<div style="font-size: 120%;">Quotient]]
+
−
* [[Documentation/How_Tos/Calc:_MOD_function|<div style="font-size: 120%;">Mod]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Logarithm/Powers</div>
+
−
* [[Documentation/How_Tos/Calc:_EXP_function|<div style="font-size: 120%;">Exp]]
+
−
* [[Documentation/How_Tos/Calc:_POWER_function|<div style="font-size: 120%;">Power]]
+
−
* [[Documentation/How_Tos/Calc:_LOG_function|<div style="font-size: 120%;">Log]]
+
−
* [[Documentation/How_Tos/Calc:_LN_function|<div style="font-size: 120%;">Ln]]
+
−
* [[Documentation/How_Tos/Calc:_LOG10_function|<div style="font-size: 120%;">Log10]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Bessel functions</div>
+
−
* [[Documentation/How_Tos/Calc:_BESSELI_function|<div style="font-size: 120%;">Besseli]]
+
−
* [[Documentation/How_Tos/Calc:_BESSELJ_function|<div style="font-size: 120%;">Besselj]]
+
−
* [[Documentation/How_Tos/Calc:_BESSELK_function|<div style="font-size: 120%;">Besselk]]
+
−
* [[Documentation/How_Tos/Calc:_BESSELY_function|<div style="font-size: 120%;">Bessely]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div>
+
−
* [[Documentation/How_Tos/Calc:_ABS_function|<div style="font-size: 120%;">Abs]]
+
−
* [[Documentation/How_Tos/Calc:_COMBIN_function|<div style="font-size: 120%;">Combin]]
+
−
* [[Documentation/How_Tos/Calc:_COMBINA_function|<div style="font-size: 120%;">Combina]]
+
−
* [[Documentation/How_Tos/Calc:_CONVERT_function|<div style="font-size: 120%;">Convert]]
+
−
* [[Documentation/How_Tos/Calc:_CONVERT_ADD_function|<div style="font-size: 120%;">Convert Add]]
+
−
* [[Documentation/How_Tos/Calc:_COUNTBLANK_function|<div style="font-size: 120%;">Countblank]]
+
−
* [[Documentation/How_Tos/Calc:_COUNTIF_function|<div style="font-size: 120%;">Countif]]
+
−
* [[Documentation/How_Tos/Calc:_DELTA_function|<div style="font-size: 120%;">Delta]]
+
−
* [[Documentation/How_Tos/Calc:_ERF_function|<div style="font-size: 120%;">Erf]]
+
−
* [[Documentation/How_Tos/Calc:_ERFC_function|<div style="font-size: 120%;">Erfc]]
+
−
* [[Documentation/How_Tos/Calc:_FACT_function|<div style="font-size: 120%;">Fact]]
+
−
* [[Documentation/How_Tos/Calc:_FACTDOUBLE_function|<div style="font-size: 120%;">Factdouble]]
+
−
* [[Documentation/How_Tos/Calc:_GCD_function|<div style="font-size: 120%;">Gcd]]
+
−
* [[Documentation/How_Tos/Calc:_GCD_ADD_function|<div style="font-size: 120%;">Gcd Add]]
+
−
* [[Documentation/How_Tos/Calc:_GESTEP_function|<div style="font-size: 120%;">Gestep]]
+
−
* [[Documentation/How_Tos/Calc:_LCM_function|<div style="font-size: 120%;">Lcm]]
+
−
* [[Documentation/How_Tos/Calc:_LCM_ADD_function|<div style="font-size: 120%;">Lcm Add]]
+
−
* [[Documentation/How_Tos/Calc:_MULTINOMIAL_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Multinomial]]
+
−
* [[Documentation/How_Tos/Calc:_PRODUCT_function|<div style="font-size: 120%;">Product]]
+
−
* [[Documentation/How_Tos/Calc:_RAND_function|<div style="font-size: 120%;">Rand]]
+
−
* [[Documentation/How_Tos/Calc:_RANDBETWEEN_function|<div style="font-size: 120%;">Randbetween]]
+
−
* [[Documentation/How_Tos/Calc:_SERIESSUM_function|<div style="font-size: 120%;">Seriessum]]
+
−
* [[Documentation/How_Tos/Calc:_SIGN_function|<div style="font-size: 120%;">Sign]]
+
−
* [[Documentation/How_Tos/Calc:_SQRT_function|<div style="font-size: 120%;">Sqrt]]
+
−
* [[Documentation/How_Tos/Calc:_SQRTPI_function|<div style="font-size: 120%;">Sqrtpi]]
+
−
* [[Documentation/How_Tos/Calc:_SUBTOTAL_function|<div style="font-size: 120%;">Subtotal]]
+
−
* [[Documentation/How_Tos/Calc:_SUM_function|<div style="font-size: 120%;">Sum]]
+
−
* [[Documentation/How_Tos/Calc:_SUMIF_function|<div style="font-size: 120%;">Sumif]]
+
−
* [[Documentation/How_Tos/Calc:_SUMSQ_function|<div style="font-size: 120%;">Sumsq]]
+
−
}}__TOC__
+
  
 
== MULTINOMIAL ==
 
== MULTINOMIAL ==
Line 111: Line 25:
  
 
=== 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 categorized as a Mathematical function, but would be more readily categorized as a Statistical function.
  
 
{{SeeAlso|EN|
 
{{SeeAlso|EN|

Latest revision as of 15:36, 31 January 2024

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.

Issues:

The multinomial distribution is a generalization of the binomial distribution in probability theory. MULTINOMIAL() is currently categorized as a Mathematical function, but would be more readily categorized as a Statistical function.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_MULTINOMIAL_function&oldid=259898"
Views
Personal tools
Navigation
Tools
In other languages