I. Intro
The GAMMA.DIST function is commonly used to calculate gamma distributions (two-parameter continuous probability distributions). GAMMA.DIST works the same as GAMMADIST.
II. About the function
- Formula: =GAMMA.DIST(x,alpha, beta,cumulative)
- Parameters:
- x (required): Used to calculate the distribution value.
- alpha (required): A distribution parameter.
- beta (required): A distribution parameter.
- cumulative (required): A logical value that determines the form of the function. If cumulative is TRUE, GAMMA.DIST will return the cumulative distribution function. If it is FALSE, it will return the probability density function.
- Note: If beta = 1, GAMMA.DIST will return the standard gamma distribution.
- Example: =GAMMA.DIST(4.79,1.234,7,TRUE)
III. Steps
Use the GAMMA.DIST function
- Select a cell and click Formulas on the toolbar, then select Statistical > GAMMA.DIST. You can also directly enter =GAMMA.DIST in a cell.
- Enter the parameters in the cell. For example: =GAMMA.DIST(4.79,1.234,7,TRUE).
- Press Enter to display the result, which is 0.3389116566 in this example.
250px|700px|reset
Delete the GAMMA.DIST function
Select the cell with the GAMMA.DIST function, then press Delete.