GAMMA.INV Function

Returns the value at a given probability of a gamma distribution.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice GAMMA.INV in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

GAMMA.INV is the reverse of GAMMA.DIST: give it a probability and it returns the value with that share of the distribution below it.

Syntax

=GAMMA.INV(probability, alpha, beta) Explain

Arguments

ArgumentRequired?What it does
probabilityYesThe share below the value, from 0 to 1.
alphaYesThe shape; must be greater than 0.
betaYesThe scale; must be greater than 0.

Examples

Example 1 — How long to quote for three repairs?

Three repairs averaging 2 hours each (alpha 3, beta 2).

B5fx=GAMMA.INV(0.9,B2,B3)
AB
1MeasureValue
2Jobs (alpha)3
3Hours per job (beta)2
4Median total5.35
590% sure10.64
=GAMMA.INV(0.9,B2,B3) Explain

Quote about 10.6 hours to be 90% sure of finishing; half the time it takes under 5.35.

Common mistakes

  • #NUM! probability is outside 0–1, or alpha or beta is 0 or negative.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.