GAMMA.DIST Function Explained
The GAMMA.DIST Function in Microsoft Excel calculates the gamma distribution, which is a type of continuous probability distribution. It returns the probability that a value selected at random from the 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 distribution is evaluated, alpha is the shape parameter, beta is the scale parameter, and cumulative is a logical value that determines the form of the function.
GAMMA.DIST Function Syntax
GAMMA.DIST(x,alpha,beta,cumulative)
- x: The value at which to evaluate the function.
- 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, GAMMA.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.