GAMMA.DIST

Formulas / GAMMA.DIST
Calculate 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.


Frequently Asked Questions

What is the GAMMA.DIST function?
The GAMMA.DIST function calculates the gamma distribution.
What is the gamma distribution used for?
The gamma distribution is used in queuing analysis.
Can X be negative when using the GAMMA.DIST function?
No, X cannot be negative when using the GAMMA.DIST function.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.


Drop CSV