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].
    Gammaln function plot.png
    • 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.