GAMMA.INV
Formulas / GAMMA.INVCalculate 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?
What is the gamma distribution?
What is the inverse of the gamma distribution?
What does the GAMMA.INV function do?
What are the inputs of the GAMMA.INV function?
What are the outputs of the GAMMA.INV function?
