INFO

This page was originally generated from official documentation.

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

Syntax

GAMMA.INV(probability, alpha, beta)
PartDescriptionNotes
probabilityThe input to the inverse gamma distribution function.* Must be between 0 and 1.
alphaThe shape of the gamma distribution.* Must be positive. * The sign of significance is ignored.
betaThe 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

AB
1Formula
2=GAMMA.INV(0.3, 5, 1)
  • GAMMA.DIST: The GAMMA.DIST function calculates the gamma distribution, a 2-parameter continuous probability distribution.