Formualizer Docs

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

ArgumentTypeRequiredDefault
probabilitynumberRequired—
alphanumberRequired—
betanumberRequired—
anumberOptional—
bnumberOptional—

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

  • A and B default to 0 and 1.

Error cases

  • Returns #NUM! when alpha <= 0, beta <= 0, probability <= 0, probability > 1, or A >= 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?.

Implementation

Engine source

On this page