GAMMADIST

Formulas / GAMMADIST
Study variables with a skewed distribution.
GAMMADIST(x,alpha,beta,cumulative)
  • x - the value to evaluate the function on
  • alpha - a parameter of the distribution
  • beta - a parameter of the distribution
  • cumulative - [OPTIONAL] the cumulative distribution function

Examples

  • =GAMMADIST(A2,A3,A4,FALSE)

    The GAMMADIST function in Sourcetable can be used to calculate the probability density of a gamma distribution. For example, the function will return the probability density of a gamma distribution using the x, alpha, and beta values in A2, A3, and A4, without the cumulative argument specified.

  • =GAMMADIST(A2,A3,A4,TRUE)

    If you want to calculate the cumulative distribution of a gamma distribution, you can use the same function with the cumulative argument specified. For example, the function will return the cumulative distribution of a gamma distribution using the x, alpha, and beta values in A2, A3, and A4, with the cumulative argument set to TRUE.

  • =GAMMADIST(x,2.5,3.5,FALSE)

    The GAMMADIST function is a great way to calculate the probability density or cumulative distribution of a gamma distribution. For example, if you wanted to calculate the probability density of a gamma distribution with an alpha value of 2.5 and a beta value of 3.5, you could use this function, where x is the x value of the gamma distribution.

  • =GAMMADIST(x,5.2,4.1,TRUE)

    If you wanted to calculate the cumulative distribution of a gamma distribution with an alpha value of 5.2 and a beta value of 4.1, you could use this function, where x is the x value of the gamma distribution.

Summary

The GAMMADIST function is used to calculate the gamma distribution, however it has been replaced with new functions for a more accurate result.

  • The GAMMADIST function is also known as the Erlang distribution.
  • The new GAMMA.DIST functions may provide improved accuracy compared to the original GAMMADIST function.


Frequently Asked Questions

What is the Gamma Distribution's probability density function?
The Gamma Distribution's probability density function is returned by the GAMMA.DIST function.
What does the GAMMA.DIST function do?
The GAMMA.DIST function returns the probability density function for the gamma distribution.
How do I use the GAMMA.DIST function?
The GAMMA.DIST function can be used to calculate the probability density function of the gamma distribution. To do this, you will need to provide the function with the following parameters:
  • x – The lower bound of the distribution.
  • alpha – The shape parameter of the distribution.
  • beta – The scale parameter of the distribution.
  • cumulative – A logical value that determines whether the function will return the cumulative distribution function or the probability density function.
What is the difference between the cumulative distribution function and the probability density function?
The cumulative distribution function (CDF) is the probability that a random variable is less than or equal to a certain value. The probability density function (PDF) is the probability that a random variable is equal to a certain value.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV