Statistical - GAMMALN.PRECISE Function

Description

The GAMMALN.PRECISE function returns the natural logarithm of the gamma function, $\Gamma \left ( x \right )$.

Syntax

GAMMALN.PRECISE(x)

Arguments

Notes

• GAMMALN.PRECISE is calculated as follows −

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

  Where,

  $$f\left ( x \right )=\left\{\begin{matrix} 0 & if \: x< 0 & \\ x & \quad\quad if \: 0 \:\leq x \leq 1 & \\ 1 & if \:x> 1& \end{matrix}\right.$$

• The number e raised to the GAMMALN.PRECISE(i) power, where i is an integer, returns the same result as (i - 1)!

• If x is nonnumeric, GAMMALN.PRECISE returns the #VALUE! error value.

• If x ≤ 0, GAMMALN.PRECISE returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example