This function returns the gamma distribution.
Syntax
GAMMA.DIST(x,alpha,beta,cumulative)
Arguments
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. |
Remarks
The equation for this function is:
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
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