The following article introduces you to the GAMMALN function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the natural logarithm of the gamma function, Γ (x).
Syntax: GAMMALN (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 (i), i is an integer, returns the same result as (i - 1) !.
- The function is calculated as follows:
[GAMMALN = 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:
- In the cell to calculate enter the formula : = GAMMALN (C6)
- Press Enter -> the natural logarithmic value of the gamma function, Γ (x) is:
- Similarly copying the formula for the remaining values results:
Where x ≤ 0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using the GAMMALN function in Excel.
Good luck!