GAMMA.DIST
Formulas / GAMMA.DISTCalculate skewed variables using GAMMA.DIST.
GAMMADIST(x,alpha,beta,cumulative)
- x - required, the value at which to evaluate the distribution
- alpha - required, a parameter to the distribution
- beta - required, a parameter to the distribution
- cumulative - required, determines the form of the function
Examples
=GAMMA.DIST(x, alpha, beta, TRUE)GAMMA.DIST can also be used to calculate the area under the curve of a given gamma distribution. For instance, calculates the area under the curve from 0 to x in a gamma distribution with parameters alpha and beta.
=GAMMA.DIST(x, (mean^2)/variance, variance/mean, cumulative)GAMMA.DIST can calculate the probability of a value in a gamma distribution with a specified mean and standard deviation. For example, this formula calculates the probability of a given value x in a gamma distribution with a mean of mean and a standard deviation of variance, with the cumulative argument set to TRUE or FALSE.
=GAMMA.DIST(probability, alpha, beta, TRUE)GAMMA.DIST can also be used to calculate the inverse of a given probability in a gamma distribution. For instance, this example calculates the inverse of a given probability in a gamma distribution with parameters alpha and beta.
Summary
The GAMMA.DIST function is used to calculate the gamma distribution, also known as the Erlang distribution. It takes five arguments - X, Alpha, Beta, Cumulative, and Cumulative - to determine the shape of the function.
- The GAMMA.DIST function returns the gamma distribution, which is commonly used in queue analysis.
- It is used to study variables with a skewed distribution.
Need help with Formulas?
Frequently Asked Questions
What is the GAMMA.DIST function?
What is the gamma distribution used for?
Can X be negative when using the GAMMA.DIST function?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.