GAMMADIST
Name
Gamma distribution
Description
Returns the gamma distribution.
Syntax
GAMMADIST(x,alpha,beta,cumulative)
Remarks
This function has the following 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:Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
GAMMADIST(A5,1,3,FALSE)
GAMMADIST(R5C1,2,1,TRUE)
GAMMADIST(4,3,2,TRUE)=0.3233235838