GAMMA. DIST Function in Excel

This guide provides a practical overview of GAMMA. DIST Function, including its main features, benefits, limitations, and important considerations.

Description: The function returns the gamma distribution , using this function to study the skewed distribution variables . Support functions from Excel 2010 onwards.

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

Inside:

- x: The value you want to calculate the gamma distribution .

- alpha: The parameter value to the distribution .

- beta: Value The parameter value to the distribution , if beta = 1 -> function returns the standard gamma distribution.

- cumulative: Logic values that define the function format include:

+ cumulative = True -> Returns the cumulative distribution function.

+ cumulative = False -> Returns the probability density function.

Attention:

- If one of the function's x, alpha, and beta arguments is not a number form -> the function returns the #VALUE! Error value

- If x <0 or alpha ? 0 or beta ? 0 -> the function returns the #NUM! Error value

- The equation for calculating the gamma probability density function is:

[fleft ({x, alpha} right) = frac {1} {{{beta ^ alpha} Gamma left (alpha right)}} {x ^ {alpha - 1}} {e ^ {- frac {N} {beta }}}]

- The equation for calculating the standard gamma probability density function is:

[fleft ({x, alpha} right) = frac {{{x ^ {alpha - 1}} {e ^ {- N}}}} {{Gamma left (alpha right)}}]

- When alpha = 1 -> function returns exponential distribution with:

[alpha = frac {1} {beta}]

- For n positive integers, if alpha = n / 2 , beta = 2 , cumulative = true -> the function returns the value (1 - CHISQ. DIST. RT (x)) with n degrees of freedom.

- If alpha is a positive integer, the function GAMMA. DIST is called the Erlang distribution.

For example:

Find the GAMMA probability distribution and density in the data table below:

- Calculate the cumulative gamma distribution . In a cell to calculate, enter the formula : = GAMMA. DIST (D6, D7, D8, D9)

- Press Enter -> GAMMA cumulative distribution is:

- Calculate the gamma probability density distribution . In a cell to calculate, enter the formula: = GAMMA. DIST (D6, D7, D8, D10)

- Press Enter -> Gamma probability density is:

Above are instructions and some specific examples when using the GAMMA. DIST function in Excel.

Good luck!