GAMMALN.PRECISE Function: Returns the natural logarithm of the gamma function, Γ(x), in Excel

This article introduces you to the GAMMALN.PRECISE function - one of the highly favored statistical functions in Excel.

Description: Returns the natural logarithm of the gamma function, Γ(x). The function is similar to GAMMALN but exclusively supports Excel 2013 onwards.

Syntax: GAMMALN.PRECISE(x)

In which:

- x: The value for which the natural logarithm of the gamma function, Γ(x), is to be calculated.

Note:

- If the value of x is not numeric -> the function returns an error value #VALUE!

- If x ≤ 0, the function returns an error value #NUM!

- The exponential e raised to the power GAMMALN.PRECISE(i), i being an integer, returns the same result as (i - 1)!.

- The function is computed as follows:

GAMMALN.PRECISE=LN(Γ(x))$GAMMALN.PRECISE=LN\left(\Gamma \left(x\right)\right)$

In which:

f(x)=⎧⎪⎨⎪⎩0ifx<0xif0≤x≤11ifx>1$f\left(x\right)=\{\begin{array}{c}0ifx<0\\ xif0\le x\le 1\\ 1ifx>1\end{array}$

Example:

Calculate the natural logarithm value of the gamma function, Γ(x), for the values in the dataset below:

- Enter the formula : =GAMMALN.PRECISE(C6) into the cell where you want to calculate.

- Press Enter -> the natural logarithm value of the gamma function, Γ(x), is:

- Similarly copy the formula for the remaining values to get the result:

- In case x ≤ 0 -> the function returns an error value #NUM!

- If x is not a number -> the function returns an error value #VALUE!

Here is the guidance and some specific examples when using the GAMMALN.PRECISE function in Excel.

Wishing you all success!