GAMMALN.PRECISE
TheGAMMALN.PRECISE
function calculates the natural logarithm of the absolute value of the gamma function for a given positive number. The gamma function is a commonly used function in mathematics and statistics. The natural logarithm of the gamma function is useful in various fields, such as physics, biology, and engineering, for modeling various phenomena.
 How to use
GAMMALN.PRECISE
formula?  Examples of using
GAMMALN.PRECISE
formula GAMMALN.PRECISE
formula not working? Similar formulas to
GAMMALN.PRECISE
Usage
Use the GAMMALN.PRECISE
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The positive number for which to calculate the natural logarithm of the gamma function.
Examples
Here are a few example use cases that explain how to use theGAMMALN.PRECISE
formula in Google Sheets.
Calculate probability density function
Calculate the probability density function for a continuous random variable using the gamma function and the natural logarithm of the gamma function.
Calculate cumulative distribution function
Calculate the cumulative distribution function for a continuous random variable using the gamma function and the natural logarithm of the gamma function.
Calculate confidence intervals
Calculate confidence intervals for a population mean or proportion using the gamma function and the natural logarithm of the gamma function.
Estimate parameters of a distribution
Estimate the parameters of a continuous probability distribution using maximum likelihood estimation and the natural logarithm of the gamma function.
Calculate moments of a distribution
Calculate the moments of a continuous probability distribution using the gamma function and the natural logarithm of the gamma function.
Common Mistakes
GAMMALN.PRECISE
not working? Here are some common mistakes people make when using the GAMMALN.PRECISE
Google Sheets Formula:
Incorrect argument type
The value provided to the GAMMALN.PRECISE formula must be a numeric value, otherwise the formula will return an error. Make sure the input value is a number.
Missing input value
If the GAMMALN.PRECISE formula is missing an input value, it will return an error. Make sure to include the input value.
Invalid input value
If the input value to the GAMMALN.PRECISE formula is negative, the formula will return an error. Make sure the input value is a positive number.
Using GAMMALN instead of GAMMALN.PRECISE
If you use the GAMMALN formula instead of GAMMALN.PRECISE, the result may be less accurate. Make sure to use the GAMMALN.PRECISE formula if you need high precision.
Incorrect syntax
If the syntax of the GAMMALN.PRECISE formula is incorrect, it will return an error. Make sure to use the correct syntax: GAMMALN.PRECISE(value).
Related Formulas
The following functions are similar to GAMMALN.PRECISE
or are often used with it in a formula:

GAMMALN
The
GAMMALN
function returns the natural logarithm of the absolute value of the Gamma function, Γ(x). The Gamma function is defined as an extension of the factorial function to complex and real numbers. The function is commonly used in probability theory and statistics to compute probabilities and to model continuous distributions such as the chisquared and F distributions. 
GAMMA.DIST
The GAMMA.DIST function calculates the gamma distribution probability for a specified x value, alpha and beta parameters. This function is often used in statistics to model continuous data that is skewed to the right. It can be used to analyze data in various fields such as finance, engineering, and social sciences.

GAMMA.INV
The
GAMMA.INV
formula returns the inverse of the cumulative distribution function for a specified probability and the Gamma distribution. It is commonly used in statistical analysis to find the value at which a specified percentage of the distribution lies. The Gamma distribution is a continuous probability distribution that is used to model the time until a certain number of events occur. 
ERF.PRECISE
The
ERF.PRECISE
function returns the error function integrated between the specified lower bound and upper bound.The error function is used to calculate the probability of a value falling within a certain range of values.
Learn More
You can learn more about the GAMMALN.PRECISE
Google Sheets function on Google Support.