GAMMADIST Function Explained
The GAMMADIST function in Microsoft Excel calculates the gamma distribution, which is a type of continuous probability distribution. It returns the probability that a variable, which follows the gamma distribution, is less than or equal to a specified value. The function takes four arguments: x, alpha, beta, and cumulative. x is the value at which the probability is calculated, alpha is the shape parameter, beta is the scale parameter, and cumulative is a logical value that determines whether the cumulative distribution function is returned (TRUE) or the probability density function is returned (FALSE).
GAMMADIST Function Syntax
GAMMADIST(x,alpha,beta,cumulative)
x: The value at which you want 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 cumulative is TRUE, GAMMADIST returns the cumulative distribution function; if FALSE, it returns the probability density function.