Quick Navigation
GAMMALN.PRECISE Function
Summary
The GAMMALN.PRECISE function computes the natural logarithm of the gamma function Γ(x), providing precise mathematical calculations for statistical analysis, probability distributions, and advanced numerical computations in Excel.
Syntax
GAMMALN.PRECISE(x)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| x | Number |
Yes | The value at which to evaluate the gamma function's natural logarithm. Must be greater than 0. |
Using the GAMMALN.PRECISE Function
GAMMALN.PRECISE delivers high-precision results for the natural logarithm of the gamma function, crucial for advanced statistical modeling, Bayesian analysis, and scientific computations where accuracy matters.
Common GAMMALN.PRECISE Examples
Basic GAMMALN.PRECISE Calculation
=GAMMALN.PRECISE(4)Returns approximately 1.7917595, which is LN(Γ(4)) or LN(6) since Γ(4) = 3! = 6.
Factorial Approximation
=EXP(GAMMALN.PRECISE(6))Returns 120, equivalent to 5! (120), demonstrating the factorial relationship.
Statistical Application
=GAMMALN.PRECISE(B2)Calculates gamma log for values in column B, useful for gamma distribution parameters.
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: Non-numeric input provided
Solution: Ensure x contains a valid number greater than 0
#NUM!
Cause: x is less than or equal to zero
Solution: Use only positive numeric values greater than 0
Notes
- Available only in Excel 2010 and later versions
- e^GAMMALN.PRECISE(n) = (n-1)! for positive integers n
- Critical for gamma, chi-squared, and exponential distributions
- More reliable for boundary values than GAMMALN
Compatibility
Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2007, Excel 2003, Earlier versions
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+