SheetFX
≡
<< Go back to all functions

GAMMADIST

The GAMMADIST function in Google Sheets is a statistical function used to calculate the gamma distribution. It is commonly used in probability and statistics to model continuous random variables. Learn how to use this function effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: GAMMADIST(x, alpha, beta, cumulative)

Parameters:

  • x: The input value for which you want to calculate the gamma distribution.
  • alpha: The shape parameter of the distribution.
  • beta: The scale parameter of the distribution.
  • cumulative: [Optional] A logical value that determines the form of the function. Set it to TRUE if you want to calculate the cumulative distribution function (CDF). Set it to FALSE or omit it if you want to calculate the probability density function (PDF).

Step-by-Step Tutorial

  1. Calculating the PDF of the Gamma Distribution:

    • Example: =GAMMADIST(2, 3, 2, FALSE)
    • Result: 0.101336

  2. Calculating the CDF of the Gamma Distribution:

    • Example: =GAMMADIST(2, 3, 2, TRUE)
    • Result: 0.657585

Use Cases and Scenarios

  1. Risk Analysis: Calculate the probability of a certain event occurring based on a gamma distribution.
  2. Quality Control: Analyze the distribution of defects in a manufacturing process.
  3. Financial Modeling: Model the time between rare events, such as insurance claims.

Related Functions

  • GAMMADIST.N: Variation of GAMMADIST that uses normalized values for the shape and scale parameters.
  • GAMMAINV: Calculate the inverse of the gamma distribution.
  • GAMMALN: Compute the natural logarithm of the gamma function.

Related Articles