Purpose
Return value
Syntax
=GAMMADIST(x,alpha,beta,cumulative)- 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.
Using the GAMMADIST function
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.
Notes
- GAMMADIST is a legacy function. For Excel 2010 and later, use the GAMMA.DIST function.
- If any argument is non-numeric, GAMMADIST returns the #VALUE! error.
- If x < 0, GAMMADIST returns the #NUM! error.
- If alpha ≤ 0 or beta ≤ 0, GAMMADIST returns the #NUM! error.
- In Excel 2007, this is a Statistical function
Related functions
GAMMA.DIST Function
The Excel GAMMA.DIST function calculates the gamma distribution, a continuous probability distribution used to model positive continuous variables. The function can return either the probability density function (PDF) to assess relative likelihood or the cumulative distribution...
GAMMA Function
The Excel GAMMA function returns the gamma function value for a given number. The gamma function is a mathematical extension of the factorial function to real numbers. For example, the following formula calculates the gamma value for 5:...
