Table of Contents
The GAMMA.INV function in Google Sheets allows users to calculate the inverse of the gamma cumulative distribution for a given probability and shape parameter. This function is useful for statistical analysis and can be used by entering the appropriate arguments in the formula bar. By using the GAMMA.INV function, users can easily and accurately calculate the inverse of the gamma distribution in their Google Sheets documents.
GAMMA.INV function
The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability, alpha, and beta parameters.
Parts of a GAMMA.INV formula
GAMMA.INV(probability, alpha, beta)
| Part | Description | Notes |
probability |
The input to the inverse gamma distribution function. |
|
alpha |
The shape of the gamma distribution. |
|
beta |
The scale of the gamma distribution. |
|
Sample formulas
GAMMA.INV(0.65, 4, 2)
GAMMA.INV(C3, 3, 2)
Note
- You can use
GAMMAINVorGAMMA.INVto perform this function.
Example
| A | B | |
| 1 | Formula | Result |
| 2 | =GAMMA.INV(0.3, 5, 1) | 3.633609083 |
Related function
- GAMMA.DIST: The GAMMA.DIST function calculates the gamma distribution, a 2-parameter continuous probability distribution.
Cite this article
stats writer (2024). How can I use the GAMMA.INV function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-gamma-inv-function-in-google-sheets/
stats writer. "How can I use the GAMMA.INV function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-gamma-inv-function-in-google-sheets/.
stats writer. "How can I use the GAMMA.INV function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-gamma-inv-function-in-google-sheets/.
stats writer (2024) 'How can I use the GAMMA.INV function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-gamma-inv-function-in-google-sheets/.
[1] stats writer, "How can I use the GAMMA.INV function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the GAMMA.INV function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.