Table of Contents
This guide provides a practical overview of GAMMA. INV Function, including its main features, benefits, limitations, and important considerations.
Description: The function returns the inverse of the gamma distribution , using this function to study their distribution variables that may be symmetrical . Support functions from Excel 2010 onwards.
Syntax: GAMMA. INV (probability, alpha, beta)
Inside:
- probability: Probability associated with the gamma distribution .
- alpha: The parameter value to the distribution .
- beta: Value The parameter value to the distribution , if beta = 1 -> function returns the standard gamma distribution.
Attention:
- If one of the probability, alpha, and beta arguments of the function is not numeric -> the function returns the #VALUE! Error value
- If alpha ? 0 or beta ? 0 -> the function returns the #NUM! Error value
- If probability> 1 or probability <0 -> the function returns the #NUM! Error value
For example:
Calculate the inverse value of the GAMMA cumulative distribution of values in the following data table:
- In the cell to calculate, enter the formula : = GAMMA. INV (D6, D7, D8)
- Press Enter -> the inverse value of the GAMMA cumulative distribution is:
- Where probability> 1 or probability function returns the #NUM! Error value
;
- Where alpha ? 0 or beta ? 0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using the GAMMA. INV function in Excel.
Good luck!
FAQ
What does the GAMMA. INV Function function do in Excel?
The GAMMA. INV Function function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the GAMMA. INV Function function correctly?
Start with an equals sign, enter GAMMA. INV Function, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the GAMMA. INV Function function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Reader Comments 0
Sign in with email or Google to join the discussion.