GAMMAINV

The GAMMAINV function in Google Sheets is used to find the inverse of the gamma cumulative distribution. It allows you to determine the value at which a given cumulative distribution occurs. Explore the comprehensive guide below to understand how to effectively apply this function.

Function Syntax and Parameters

Syntax: GAMMAINV(probability, alpha, beta)

Parameters:

• probability: The probability associated with the gamma distribution.
• alpha: The shape parameter of the gamma distribution.
• beta: The scale parameter of the gamma distribution.

Step-by-Step Tutorial

1. Using GAMMAINV with specific inputs:

   • Example: =GAMMAINV(0.5, 2, 3)
   • Result: The result is the value 4.633213.

2. Using GAMMAINV with cell references:

   • Example: If cell A1 contains the probability 0.25, cell A2 contains the alpha value 3, and cell A3 contains the beta value 2, then =GAMMAINV(A1, A2, A3) will return the corresponding value based on the given inputs.

Use Cases and Scenarios

1. Risk Analysis: Determine the value at which a specific level of risk occurs.
2. Quality Control: Identify the time at which a certain proportion of defects is expected.
3. Reliability Engineering: Calculate the time at which a certain percentage of failures is projected.

Related Functions

• GAMMA.DIST: Calculate the gamma probability density function.
• GAMMALN: Compute the natural logarithm of the absolute value of the gamma function.

Related Articles

• Understanding Statistical Functions in Google Sheets
• How to Calculate Multiple Probabilities in Google Sheets