How to use the GAMMADIST function
Author: Oscar Cronquist Article last updated on October 23, 2018
The GAMMADIST function calculates the gamma often used in queuing analysis in probability statistics.
This function is outdated and has been replaced by the GAMMA.DIST function which was introduced in Excel 2010.
Formula in cell C7:
=GAMMADIST(C3,C4,C5,C6)
Excel Function Syntax
GAMMADIST(x,alpha,beta,cumulative)
Arguments
| x | Required. |
| alpha | Required. |
| beta | Required. 1 returns the standard gamma distribution. |
| cumulative | Required. A boolean value. TRUE - cumulative distribution function FALSE - probability density function |
Comments
The GAMMADIST function returns
- #VALUE! error value if alpha, beta or x is non-numeric.
- #NUM! error value if:
- x < 0 (zero)
- alpha <= 0 (zero)
- beta <= 0 (zero)
The equation to calculate the gamma probabiltiy density function:
The standard gamma probability function:
Functions in 'Compatibility' category
The GAMMADIST function function is one of many functions in the 'Compatibility' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form