GAMMA.INV function

The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability, alpha, and beta parameters.

Parts of a GAMMA.INV formula

GAMMA.INV(probability, alpha, beta)

Part Description Notes
probability The input to the inverse gamma distribution function.
  • Must be between 0 and 1.
alpha The shape of the gamma distribution.
  • Must be positive.
  • The sign of significance is ignored.
beta The scale of the gamma distribution.
  • Must be positive.

Sample formulas

GAMMA.INV(0.65, 4, 2)

GAMMA.INV(C3, 3, 2)

Note

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

Example

  A B
1 Formula Result
2 =GAMMA.INV(0.3, 5, 1) 3.633609083

Related function

  • GAMMA.DIST: The GAMMA.DIST function calculates the gamma distribution, a 2-parameter continuous probability distribution.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
9278610738538383169
true
Search Help Center
true
true
true
true
true
35
false
false