Documentation/Calc Functions/GAMMALN.PRECISE
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
GAMMALN.PRECISE
Category:
Statistical Analysis
Summary:
Calculates the natural logarithm of a gamma function value.
For positive values of x, the gamma function grows rapidly as x increases. However, the natural logarithm of the gamma function grows much more slowly with x and can often be easier to work with.
Syntax:
GAMMALN.PRECISE(Number)
Returns:
Returns a real number, which is the natural logarithm of the gamma function for the number passed as argument.
Arguments:
Number is a real number, or a reference to a cell containing that number, for which the natural logarithm of the gamma function is to be calculated.
- If Number is non-numeric, then GAMMALN.PRECISE reports a #VALUE! error.
- If Number is less than or equal to 0, then GAMMALN.PRECISE reports an invalid argument error (Err:502).
Additional details:
- Calc's GAMMALN and GAMMALN.PRECISE functions perform identical calculations. The requirements for GAMMALN are specified in ODF 1.2; GAMMALN.PRECISE is provided for interoperability with Microsoft Excel.
- [math]\displaystyle{ \text{GAMMALN.PRECISE}(x)~=~\text{LN}(\text{GAMMA}(x)) }[/math].
- The following figure shows a plot of the GAMMALN.PRECISE function for numbers x in the range (0, 8].
- For more information about the natural logarithm of the gamma function, visit Wikipedia's Gamma function page.
Examples:
Formula | Description | Returns |
---|---|---|
=GAMMALN.PRECISE(A1) where cell A1 contains the number 10. | Calculates the natural logarithm of the gamma function for an input value of 10. | 12.8018274800815 |
=GAMMALN.PRECISE(2) | Calculates the natural logarithm of the gamma function for an input value of 2. | 0 |
=GAMMALN.PRECISE(0.5) | Calculates the natural logarithm of the gamma function for an input value of 0.5. | 0.5723649429247 |
Related LibreOffice functions:
ODF standard:
None
Related (or similar) Excel functions:
GAMMALN.PRECISE since v.2010.