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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.