GAMMALN Function

Basic Description

The Excel Gammaln function returns the natural logarithm of the Gamma Distribution.

Syntax: GAMMALN( x )

where x is the positive value at which you want to evaluate the function.

 

Chart of the Natural Logarithm of the Gamma Distribution

Natural Logarithm of the Gamma Distribution

Gammaln Function Example

The chart on the right shows the natural logarithm of the Gamma Distribution. If you want to calculate the value of this function at x = 4.5, this can be done by the Excel Gammaln function, as follows:

=GAMMALN( 4.5 )

This gives the result 2.453736571.

 

Gammaln Function Errors

If you get an error from the Excel Gammaln function this is likely to be one of the following :

#NUM! Occurs if the supplied value of x is ≤ 0
#VALUE! Occurs if the supplied value of x is not recognised as a numeric value

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment