Home › Functions › Statistical › GAMMA.DIST
fx
GAMMA.DIST
Statistical  ·  Since: Excel 2003  ·  9 languages

Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis.

🌐 Translations

English GAMMA.DIST
Deutsch GAMMA.VERT
Français LOI.GAMMA.N
Español DISTR.GAMMA.N
Italiano DISTRIB.GAMMA.N
Português DIST.GAMA
Nederlands GAMMA.VERD.N
Polski ROZKŁ.GAMMA
Русский ГАММА.РАСП

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

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

Arguments

x (required) — The value at which you want to evaluate the distribution.
alpha (required) — A parameter to the distribution.
beta (required) — A parameter to the distribution. If beta = 1, GAMMA.DIST returns the standard gamma distribution.
cumulative (required) — A logical value that determines the form of the function. If cumulative is TRUE, GAMMA.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

▶ Examples

=GAMMA.DIST(A2,A3,A4,TRUE)
=GAMMA.DIST(A2,A3,A4,FALSE)

Related functions

Copied to clipboard