Name
GAMMADIST
Synopsis
Use GAMMADIST to find probabilities for the gamma distribution. This type of distribution is typically used in queuing analysis to study variables with skewed distributions.
To Calculate
=GAMMADIST(X,Alpha,Beta,Cumulative)
All arguments are required for this function.
-
X Specifies a positive numeric value that should be used to evaluate the function.
Example
Figure 15-18 illustrates how GAMMADIST is used to
find the gamma distribution. The figure shows how the function
returns a different value based upon the logical value specified for
the Cumulative argument. You will also
notice in this example that GAMMAINV returns a value that matches the
initial X value specified for GAMMADIST.
GAMMALN determines the natural logarithm value for the gamma
function.
Figure 15-18. Use GAMMADIST and GAMMAINV to determine gamma distributions
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
