This function returns the gamma distribution.
GAMMADIST(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 mass function. |
The equation for this function is:
Accepts numeric data for all arguments. Returns numeric data.
GAMMADIST(A5,1,3,FALSE)
GAMMADIST(R5C1,2,1,TRUE)
GAMMADIST(4,3,2,TRUE) gives the result 0.3233235838
GAMMADIST(4,3,2,FALSE) gives the result 0.1353352832