GAMMALN.PRECISE function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel

The following article introduces you to the GAMMALN.PRECISE function - one of the functions in the statistical function group is very popular in Excel.

GAMMALN.PRECISE function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel Picture 1

Description: The function returns the natural logarithm of the gamma function, Γ (x). The function is not different from the GAMMALN function, but the function only supports versions from Excel 2013 onwards.

Syntax: GAMMALN.PRECISE (x)

Inside:

- x: The value you want to calculate the natural logarithm of the gamma function, Γ (x). .

Attention:

- If the function's x value is not numeric -> the function returns the #VALUE! Error value

- If x ≤ 0 the function returns the #NUM! Error value

- The exponent e of GAMMALN.PRECISE (i), i is an integer, returns the same result as (i - 1) !.

- The function is calculated as follows:

[GAMMALN.PRECISE = LNleft ({Gamma left (x right)} right)]

Inside:

(fleft (x right) = left {{begin {array} {* {20} {c}}
{0 ,,,,,,, {rm {if}}, x <0}
{x ,,,, { rm {if}}, 0 le x le 1}
{1 ,,,,,,,, {rm {if}}, x> 1}
end {array}} right.,)

For example:

Calculate the natural logarithm value of the gamma function, Γ (x) of the values ​​in the following data table:

GAMMALN.PRECISE function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel Picture 2

- In the cell to calculate enter the formula : = GAMMALN.PRECISE (C6)

GAMMALN.PRECISE function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel Picture 3

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

GAMMALN.PRECISE function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

GAMMALN.PRECISE function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel Picture 5

- Where x ≤ 0 -> the function returns the #NUM! Error value

GAMMALN.PRECISE function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel Picture 6

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

GAMMALN.PRECISE function - The function returns the natural logarithm of the gamma function, Γ (x) in Excel Picture 7

Above are instructions and some specific examples when using the GAMMALN.PRECISE function in Excel.

Good luck!