The GAMMA.DIST function calculates the gamma distribution probability for a given value in Excel. This function is commonly used in statistics and probability analysis to model continuous random variables.


=GAMMA.DIST(X, Alpha, Beta, Cumulative)

X The value at which you want to evaluate the distribution.
Alpha Parameter alpha of the gamma distribution.
Beta Parameter beta of the gamma distribution.
Cumulative A logical value that determines the form of the function. If TRUE GAMMA.DIST returns the cumulative distribution function; if FALSE it returns the probability density function.
Cumulative = TRUE The cumulative distribution function. If FALSE it returns the probability density function.
Cumulative = FALSE The probability density function. If TRUE it returns the cumulative distribution function.


When you need to analyze random variables following a gamma distribution, turn to the GAMMA.DIST function in Excel. This function proves valuable in statistical analysis and probability modeling, aiding in the assessment of outcomes for continuous random variables with non-negative values. By utilizing GAMMA.DIST, you gain insights into the likelihood of specific values occurring within a gamma distribution, pivotal for informed decision-making in diverse fields such as finance, healthcare, and risk assessment.

To maximize the utility of GAMMA.DIST, provide essential parameters that define the gamma distribution under examination. Include the value at which you seek the distribution evaluation (X), along with the parameters Alpha and Beta that characterize the specific gamma distribution's shape and scale, respectively. The logical input in the Cumulative argument determines whether the function computes the cumulative distribution function or the probability density function.

A distinguishing feature of GAMMA.DIST lies in its ability to cater to varied analytical needs. With the flexibility to assess cumulative distribution or probability density, you can tailor the function's output to suit your specific statistical inquiries, offering a nuanced perspective on the gamma distribution probabilities.

In essence, GAMMA.DIST emerges as a fundamental tool in Excel for examining gamma distribution probabilities, empowering you to unravel the intricacies of random variables and probability distributions with confidence and precision.


Suppose you are analyzing a process that follows a gamma distribution with Alpha = 2 and Beta = 3. You want to determine the probability of observing a value less than or equal to 8. Using the GAMMA.DIST function with Cumulative = TRUE, the formula would be:

=GAMMA.DIST(8, 2, 3, TRUE)

Consider a scenario where the parameters of a gamma distribution are Alpha = 2 and Beta = 3, and you aim to ascertain the likelihood of a specific value, say 5, occurring. By employing GAMMA.DIST with Cumulative = FALSE, the formula to compute the probability density function would be:



What does the 'Alpha' parameter represent in the GAMMA.DIST function?

The 'Alpha' parameter in the GAMMA.DIST function signifies the shape parameter of the gamma distribution. It governs the skewness and shape of the distribution curve, influencing the probability outcomes for the random variable under consideration.

How does the 'Beta' parameter impact the gamma distribution in the GAMMA.DIST function?

The 'Beta' parameter in the GAMMA.DIST function corresponds to the scale parameter of the gamma distribution. It plays a crucial role in determining the spread or variance of the distribution, influencing the range and diversity of the possible outcomes for the random variable.

What is the significance of the 'Cumulative' argument in the GAMMA.DIST function?

The 'Cumulative' argument in the GAMMA.DIST function governs the type of distribution function to compute. When set to TRUE, the function calculates the cumulative distribution function; when set to FALSE, it derives the probability density function, tailoring the function's output based on the analytical requirements.

Related functions