GAMMA.INV

Formulas / GAMMA.INV
Calculate the inverse of a gamma distribution.
=GAMMA.INV(probability,alpha,beta)
  • probability - required argument associated with the gamma distribution
  • alpha - required parameter of the distribution
  • beta - required parameter of the distribution

Examples

  • =GAMMA.INV(A2,A3,A4)

    The GAMMA.INV function can be used to calculate the inverse of the gamma cumulative distribution, and takes in values for A2, A3, and A4 and returns the inverse of the gamma cumulative distribution.

  • =GAMMA.INV(0.5,5,0.1)

    To demonstrate this, let's say we have three values: A2 = 0.5, A3 = 5, and A4 = 0.1. We can use the formula to calculate the inverse of the gamma cumulative distribution for these values. The result of this calculation is 4.1614.

  • =GAMMA.INV(0.5,5,0.1,4.1614)

    The GAMMA.INV function can also be used to calculate the probability of a random variable X taking on a value less than or equal to x. For example, if we want to calculate the probability of X taking on a value less than or equal to 4.1614 when A2 = 0.5, A3 = 5, and A4 = 0.1, we can use this formula. The result of this calculation is 0.5.


Summary

GAMMA.INV is a function which is used to calculate the inverse of the gamma cumulative distribution. It is an important tool for statistical analysis.

  • The GAMMA.INV function returns the inverse of the gamma distribution using an iterative search method.
  • The GAMMA.INV function examines a variable whose distribution may be skewed.

Frequently Asked Questions

What is the GAMMA.INV function?
The GAMMA.INV function is a statistical tool used to return the inverse of the gamma distribution.
What is the gamma distribution?
The gamma distribution is a type of probability distribution that is used to model the time between events in a Poisson point process, or to describe the distribution of waiting times between Poisson distributed events.
What is the inverse of the gamma distribution?
The inverse of the gamma distribution is the inverse function of the gamma distribution, which is used to calculate the probability of a given value occurring in the distribution.
What does the GAMMA.INV function do?
The GAMMA.INV function returns the inverse of the gamma distribution, which can be used to calculate the probability of a given value occurring in the distribution.
What are the inputs of the GAMMA.INV function?
The inputs of the GAMMA.INV function are the shape (alpha) and scale (beta) parameters of the gamma distribution.
What are the outputs of the GAMMA.INV function?
The output of the GAMMA.INV function is the inverse of the gamma distribution, which is used to calculate the probability of a given value occurring in the distribution.

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