WorksheetFunction.Gamma_Dist (Excel)

Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis.

If x, alpha, or beta is nonnumeric, Gamma_Dist returns the #VALUE! error value. If x < 0, Gamma_Dist returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, Gamma_Dist returns the #NUM! error value. The equation for the gamma probability density function is:

Gamma_Dist (Arg1, Arg2, ..., Arg4)

``````
Dim dblArg1 As Double: dblArg1 =
Dim dblArg2 As Double: dblArg2 =
Dim dblArg3 As Double: dblArg3 =
Dim dblGamma_Dist As Double
dblGamma_Dist = WorksheetFunction.Gamma_Dist(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3, Arg4:=True)
``````

Arguments

Arg1, Arg2, ..., Arg4

Arg1 (Double) - X - the value at which you want to evaluate the distribution.

Arg2 (Double) - Alpha - a parameter to the distribution.

Arg3 (Double) - Beta - a parameter to the distribution. If beta = 1, Gamma_Dist returns the standard gamma distribution.

Arg4 (Boolean) - Cumulative - a logical value that determines the form of the function. If cumulative is True, Gamma_Dist returns the cumulative distribution function; if False, it returns the probability density function.