GAMMAINV

Formulas / GAMMAINV
Study a variable whose distribution is skewed.
=GAMMAINV(probability,alpha,beta)
  • Probability - required, probability associated with the gamma distribution
  • Alpha - required, parameter of the distribution
  • Beta - required, parameter of the distribution

Examples

  • =GAMMAINV(1,2,3)

    The GAMMAINV function can be used to compute the inverse of the gamma distribution for given arguments. For example, this would return the inverse of the gamma distribution for arguments 1, 2, and 3.

  • =GAMMAINV(LOG(A2),A3,A4)

    The GAMMAINV function can also be used with other Sourcetable functions, such as the LOG function. For example, this formula would return the inverse of the gamma distribution for the log of argument A2, and arguments A3 and A4.

  • =GAMMAINV(A5,B5,C5)

    The GAMMAINV function can also be used to calculate the inverse of the gamma distribution for a range of values. This example would return the inverse of the gamma distribution for the arguments in the cells A5, B5, and C5.

  • =GAMMAINV(NORM.INV(A2),A3,A4)

    The GAMMAINV function can also be used with other statistical functions, such as the NORM.INV function. For example, this would return the inverse of the gamma distribution for the inverse of the normal distribution of argument A2, and arguments A3 and A4.


Summary

GAMMAINV is a mathematical function used to calculate the inverse of the gamma distribution. It utilizes an iterative search technique to find the inverse.

  • The GAMMA.INV function is used to calculate the inverse of the gamma distribution.
  • This inverse calculation is used to estimate the probability of a gamma distribution.
  • The inverse calculation is also used to determine the value of a given probability.

Frequently Asked Questions

What is the GAMMAINV Function?
The GAMMAINV Function is a statistical function that calculates the inverse of the gamma cumulative distribution. This function is used to study a variable whose distribution is skewed. The GAMMAINV function requires three arguments; probability, alpha, and beta.
How do I use the GAMMAINV Function?
The GAMMAINV function is used by entering the following formula in a cell: GAMMAINV(probability, alpha, beta). The probability argument is the probability value for which you wish to calculate the inverse of the gamma cumulative distribution. The alpha argument is the shape parameter of the gamma distribution, and the beta argument is the scale parameter of the gamma distribution.
What happens if I enter text as an argument?
If any argument entered is text, the GAMMAINV function will return the #VALUE! error.
What are the parameters of the GAMMAINV Function?
The parameters of the GAMMAINV Function are as follows:
  • Probability: Required argument. This is the probability value for which you wish to calculate the inverse of the gamma cumulative distribution.
  • Alpha: Required argument. This is the shape parameter of the gamma distribution.
  • Beta: Required argument. This is the scale parameter of the gamma 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