Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

GAMMA.INV

Returns the inverse of the gamma cumulative distribution for the specified probability, alpha and beta parameters.

 

Sample Usage

GAMMA.INV(0.5,4,2)
GAMMA.INV(A2,A3,A4)

 

Syntax

GAMMA.INV(probability, alpha, beta)

  • probability - The probability at which to evaluate the function.
  • alpha - A parameter to the distribution.
  • beta - A parameter to the distribution.

Examples

GAMMA.INV(0.5,4,2) returns a value of 7.3441.
GAMMA.INV(A2,A3,A4) returns the inverse of the gamma cumulative distribution for the probability, alpha, and beta arguments in A2, A3 and A4. 

 

Notes

  • You can use GAMMA.INV or GAMMAINV to perform this function.