BETAINV
Returns the inverse of the cumulative beta distribution (legacy name).
BETAINV(probability, alpha, beta, [A], [B]) is the x with
BETADIST(x, alpha, beta, A, B) = probability.
The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.
Syntax
=BETAINV(probability, alpha, beta, [a], [b])
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
probability | number | Required | — |
alpha | number | Required | — |
beta | number | Required | — |
a | number | Optional | — |
b | number | Optional | — |
How it works
Legacy spelling of BETA.INV with the same argument order. Finds the point in the supplied interval whose cumulative beta probability matches probability. Both shape parameters must be positive.
Remarks
AandBdefault to0and1.
Error cases
- Returns
#NUM!whenalpha <= 0,beta <= 0,probability <= 0,probability > 1, orA >= B.
Examples
Use the legacy name to locate the half-probability point in the unit interval.
Formula =BETAINV(0.5,2,3)
Expected result 0.38572756813239
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Supply zero and ten as the legacy function’s optional endpoints.
Formula =BETAINV(0.5,2,3,0,10)
Expected result 3.8572756813239
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
A cumulative probability of one maps to the upper bound.
Formula =BETAINV(1,2,3)
Expected result 1
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
A probability above one is outside the distribution.
Formula =BETAINV(1.1,2,3)
Expected result #NUM!
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Find the 70th percentile for shape parameters 8 and 10 on the interval from 1 to 3.
Formula =BETAINV(0.7,8,10,1,3)
Expected result 2.00989202077018
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.