ID EN
…
#Statistical

GAMMADIST

Excel Functions

Get the PDF or CDF of the gamma distribution

Syntax

EXCEL 
=GAMMADIST(x, alpha, beta, cumulative)

Arguments

Parameter Description
x The value at which to evaluate the distribution.
alpha The shape parameter of the distribution.
beta The scale parameter of the distribution.
cumulative A logical value that determines the form of the function. If TRUE, returns the cumulative distribution function; if FALSE, returns the probability density function.

Return Value

Probability density or cumulative probability value

Details

The GAMMADIST function calculates values for the gamma distribution, which is a continuous probability distribution commonly used in statistical analysis. The gamma distribution is particularly useful for modeling positive continuous variables and has applications in reliability analysis, queuing theory, and meteorology. For better accuracy and consistency with other modern statistical functions, it is recommended to use the GAMMA.DIST function. GAMMA.DIST uses the same arguments and provides the same core functionality with improved numerical precision. See the GAMMA.DIST function for more details.

See Also

GAMMA.DIST GAMMA