Documentation/Calc Functions/GAMMALN.PRECISE

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

GAMMALN.PRECISE

Category:

Statistical Analysis

Summary:

Returns the natural logarithm of a gamma function value. The natural logarithm of the gamma function grows much more slowly than the gamma function and it is often more convenient to add and subtract logs instead of multiplying and dividing very large values.

Syntax:

GAMMALN.PRECISE(Number)

Returns:

Returns a real number which is the same as LN(GAMMA(N)) where N is the Number.

Arguments:

Number is a real number or a reference to the cell containing that number for which the Gamma function value is to be calculated.

  • If Number is a less than equal to zero, then the function returns an error value.

Additional details:

  • The formula for the GAMMALN.PRECISE is:
Gammaln.precise.png

where N is the Number

  • For more details on the natural logarithm of the Gamma function, visit Wikipedia

Examples:

Formula Description Returns
=GAMMALN.PRECISE(2) The function calculates the natural logarithm of the gamma function value of 2 0
=GAMMALN.PRECISE(10) The function calculates the natural logarithm of the gamma function value of 10 12.8018274800815
=GAMMALN.PRECISE(2.8) The function calculates the natural logarithm of the gamma function value of 2.8 0.516702791987746
=GAMMALN.PRECISE(-2.8) The function returns an error for negative values of Number. Err:502
=GAMMALN.PRECISE(0) The function returns an error for 0 value of Number. Err:502

Related LibreOffice functions:

GAMMA.DIST

GAMMA.INV

GAMMADIST

GAMMAINV

GAMMA

GAMMALN

ODF standard:

None

Equivalent Excel functions:

GAMMALN.PRECISE