GAMMA.DIST()/GAMMADIST()

Syntax. GAMMA.DIST(x,alpha,beta,cumulative)

Definition. This function returns the probabilities of a gamma-distributed random variable. Use this function to examine variables that have a skewed distribution. The gamma distribution is commonly used in queuing analyses.

Arguments

  • x (required). The value (quantile) for which you want to calculate the probability (1-alpha).

  • alpha (required). A parameter of the distribution.

  • beta (required). A parameter of the distribution. If beta = 1, GAMMA.DIST() returns the standard gamma distribution.

  • cumulative (required). The logical value that represents the type of the function. If cumulative is TRUE, GAMMA.DIST() returns the value of the distribution function that is the probability that ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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.