This function returns the gamma distribution.
GAMMA.DIST(x,alpha,beta,cumulative)
This function has these arguments:
Argument | Description |
---|---|
x | Value at which to evaluate the distribution |
alpha | Alpha parameter of the distribution |
beta | Beta parameter of the distribution |
cumulative | Logical value that determines the form of the function If cumulative is TRUE, then this function returns the cumulative distribution function; if FALSE, it returns the probability density function. |
The equation for this function is:
Accepts numeric data for all arguments. Returns numeric data.
GAMMA.DIST(A5,1,3,FALSE)
GAMMA.DIST(R5C1,2,1,TRUE)
GAMMA.DIST(4,3,2,TRUE) gives the result 0.3233235838169362
GAMMA.DIST(4,3,2,FALSE) gives the result 0.1353352832366127