SheetFX
≡
<< Go back to all functions

GAMMA.DIST

The GAMMA.DIST function in Google Sheets is a powerful tool for calculating the gamma distribution, which is a two-parameter continuous probability distribution. This function is commonly used in statistics and probability theory. With the GAMMA.DIST function, you can calculate the probability density or cumulative distribution for a given value.

Function Syntax and Parameters

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

Parameters:

  • x: The value at which you want to evaluate the distribution.
  • alpha: The shape parameter of the gamma distribution.
  • beta: The scale parameter of the gamma distribution.
  • cumulative: [Optional] A logical value that determines the type of distribution. If set to TRUE or 1, the function returns the cumulative distribution. If set to FALSE or 0, the function returns the probability density.

Step-by-Step Tutorial

To use the GAMMA.DIST function in Google Sheets, follow these steps:

  1. Basic Usage:

    • Example: =GAMMA.DIST(2, 3, 2, FALSE)
    • Result: The probability density of the gamma distribution at x = 2 with shape parameter alpha = 3 and scale parameter beta = 2 is returned.

  2. Cumulative Distribution:

    • Example: =GAMMA.DIST(4, 2, 3, TRUE)
    • Result: The cumulative distribution of the gamma distribution at x = 4 with shape parameter alpha = 2 and scale parameter beta = 3 is returned.

Use Cases and Scenarios

Here are some common use cases for the GAMMA.DIST function:

  1. Probability Calculations: Calculate the probability density or cumulative distribution for a given value in a gamma distribution.
  2. Statistical Analysis: Perform statistical analysis involving the gamma distribution.
  3. Risk Assessment: Use the gamma distribution to model and analyze risks in probabilistic models.

Related Functions

  • GAMMA.INV: Calculates the inverse of the gamma cumulative distribution.

Related Articles