Menu
EXCEL GAMMA.INV FUNCTION
Excel GAMMA.INV Function Introduction
The inverse of the Gamma Cumulative Distribution is returned by the Excel Gamma.Inv function. Because the function is new in Excel 2010, it is not available in previous versions of Excel. The Gamma.Inv function, on the other hand, is merely a new version of the Gammainv function, which was accessible in prior versions of Excel.
Description of Excel GAMMA.INV Function
Syntax :
=GAMMA.INV( probability, alpha, beta )
Parameters :
The following parameters are :
- Probability – The probability value (between 0 and 1) for which the inverse of the Gamma Cumulative Distribution Function should be calculated.
- Alpha – A distribution parameter.
- Beta – is a distribution parameter.
- (It should be noted that if beta=0, this describes the inverse of the Standard Gamma Distribution.)
Step By Step Guide of GAMMA.INV Function
Example :
The graphs below depict the Gamma Cumulative Distribution and the Inverse Gamma Cumulative Distribution, with alpha = 3 and beta = 2. For a given probability, the Excel Gamma.Inv function may be used to determine the value of the Inverse Gamma Cumulative Distribution function. For example, for a probability of 0.5, the function is: =GAMMA.INV(0.5, 3, 2), yielding the value 5.348120627.
Key Points
- #NUM! – Occurs if any of the following conditions are met: the supplied probability value is 0 or 1; the supplied alpha is 0; or the supplied beta is 0.
- #N/A- Occurs when Excel fails to find a solution after 64 iterations.
- #VALUE!- This error occurs if any of the given parameters is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
