Statistical
Excel 2010
◉ 15 views
=BETA.INV()
.INV(probability,alpha,beta,[A],[B])
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=BETA.INV(probability,alpha,beta,[A],[B])
Hover argument names in the table for details.
Output typeNumber
Popularity5 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =BETA.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 |
|---|---|---|---|
beta |
Number | Required | .INV(probability,alpha,beta,[A],[B]) |
probability |
Number | Required | A probability associated with the beta distribution. |
alpha |
Number | Required | A parameter of the distribution. |
A |
Number | Optional | A lower bound to the interval of x. |
B |
Number | Optional | An upper bound to the interval of x. |
▣ Examples
▦ Data
| Cell | Value | Description |
|---|---|---|
A2 |
0.685470581 | Probability associated with the beta distribution |
A3 |
8 | Parameter of the distribution |
A4 |
10 | Parameter of the distribution |
A5 |
1 | Lower bound |
A6 |
3 | Upper bound |
A7 |
0.685470581 | Probability associated with the beta distribution |
A8 |
8 | Parameter of the distribution |
A9 |
10 | Parameter of the distribution |
A10 |
1 | Lower bound |
A11 |
3 | Upper bound |
Inverse of the cumulative beta probability density function for the parameters above.
=BETA.INV(A2,A3,A4,A5,A6)
Result:
2
§ Remarks
- If any argument is nonnumeric, BETA.INV returns the #VALUE! error value.
- If alpha ≤ 0 or beta ≤ 0, BETA.INV returns the #NUM! error value.
- If probability ≤ 0 or probability > 1, BETA.INV returns the #NUM! error value.
- If you omit values for A and B, BETA.INV uses the standard cumulative beta distribution, so that A = 0 and B = 1.
- Given a value for probability, BETA.INV seeks that value x such that BETA.DIST(x, alpha, beta, TRUE, A, B) = probability. Thus, precision of BETA.INV depends on precision of BETA.DIST.
✦ Tips
- If you omit values for A and B, BETA.INV uses the standard cumulative beta distribution, so that A = 0 and B = 1.
- Given a value for probability, BETA.INV seeks that value x such that BETA.DIST(x, alpha, beta, TRUE, A, B) = probability. Thus, precision of BETA.INV depends on precision of BETA.DIST.
⚠ Common Errors
#VALUE!
If any argument is nonnumeric, BETA.INV returns the #VALUE! error value.
Fix: همه آرگومانها را بررسی کنید و مطمئن شوید عدد هستند؛ موارد متنی یا خانههای خالی را به عدد تبدیل کنید.
#NUM!
If alpha ≤ 0 or beta ≤ 0, BETA.INV returns the #NUM! error value. If probability ≤ 0 or probability > 1, BETA.INV returns the #NUM! error value.
Fix: Correct the input value
💬 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!