Jump to content

Documentation/Calc Functions/GAMMALN.PRECISE

From The Document Foundation Wiki
This page contains changes which are not marked for translation.

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:

FACT

GAMMA

GAMMALN

ODF standard:

None

Related (or similar) Excel functions:

GAMMALN.PRECISE since v.2010.