Buzz
Another computational function besides GAMMADIST that utilizes the gamma cumulative distribution in statistical probability is the GAMMAINV function. Through this guide, you will learn how to use the GAMMAINV function in Excel to calculate values of the aforementioned gamma cumulative distribution.
GAMMAINV Function in Excel
Guide on Using GAMMAINV Function in Excel - Illustrated Examples
Syntax: GAMMAINV(probability, alpha, beta)
Where:
- probability: Required – Probability associated with the gamma distribution.
- Alpha: Required – A parameter to the distribution.
Consider an Example
Input real values in Excel corresponding to the parameters of the GAMMAINV function in the Excel cells. In this example, we compute with Probability associated with the gamma distribution as 0.0735, Alpha parameter of the distribution is 8, and Beta parameter of the distribution is 3:
Enter the formula in cell C9. And the calculated result of the function received is 13.00013994:
So, now you've got the hang of using the GAMMAINV function in Excel. Remember, the value of the Beta parameter of the distribution matters. If you input beta = 1, the function will return a standard gamma distribution for you. However, if beta is a non-positive number, the function will return an error value. You can employ the GAMMAINV function across Office 2013, Office 2010, Office 2007, and Office 2003 versions.
Using the OFFSET function is straightforward, but at the very least, you need to remember its syntax. If you can't recall it, refer back to the article on Mytour for guidance.
