Statistical
Excel 2010
◉ 15 views
=GAMMA.INV()
Returns the inverse of the gamma cumulative distribution. If p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x. You can use this function to study a variable whose distribution may be skewed.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=GAMMA.INV(probability,alpha,beta)
Hover argument names in the table for details.
Output typeNumber
Popularity4 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =GAMMA.INV() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
probability |
Number | Required | The probability associated with the gamma distribution. |
alpha |
Number | Required | A parameter to the distribution. |
beta |
Number | Required | A parameter to the distribution. If beta = 1, GAMMA.INV returns the standard gamma distribution. |
▣ Examples
▦ Data
| Cell | Value | Description |
|---|---|---|
A2 |
0.068094 | Probability associated with the gamma distribution |
A3 |
9 | Alpha parameter to the distribution |
A4 |
2 | Beta parameter to the distribution |
A5 |
0.068094 | Probability associated with the gamma distribution |
A6 |
9 | Alpha parameter to the distribution |
A7 |
2 | Beta parameter to the distribution |
Inverse of the gamma cumulative distribution for the probability, alpha, and beta arguments in A2, A3, and A4.
=GAMMA.INV(A2,A3,A4)
Result:
10.0000112
§ Remarks
- If any argument is text, GAMMA.INV returns the #VALUE! error value.
- If probability < 0 or probability > 1, GAMMA.INV returns the #NUM! error value.
- If alpha ≤ 0 or if beta ≤ 0, GAMMA.INV returns the #NUM! error value.
- Given a value for probability, GAMMA.INV seeks that value x such that GAMMA.DIST(x, alpha, beta, TRUE) = probability. Thus, precision of GAMMA.INV depends on precision of GAMMA.DIST. GAMMA.INV uses an iterative search technique. If the search has not converged after 64 iterations, the function returns the #N/A error value.
⚠ Common Errors
#VALUE!
If any argument is text, GAMMA.INV returns the #VALUE! error value.
Fix: همه آرگومانها را بررسی کنید و مقدار عددی وارد کنید.
#NUM!
If probability < 0 or probability > 1, GAMMA.INV returns the #NUM! error value. If alpha ≤ 0 or if beta ≤ 0, GAMMA.INV returns the #NUM! error value.
Fix: Correct the input value
#N/A
If the search has not converged after 64 iterations, the function returns the #N/A error value.
Fix: مقادیر ورودی را بررسی کنید یا با مقادیر probability متفاوت دوباره تلاش کنید.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!