ExcelFlux

BETAINV function

the inverse of the cumulative distribution function for a specified beta distribution.

Compatibility

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find the cutoff for a beta proportion at the given probability. The probability refers to the lower tail.

A worked example from the workbook

RowA
6Probability
70.1
80.5
90.9
Record 1
=BETAINV(A7,2,3)

Expected result0.1425593167

See the inputs and instructions for all 3 examples

Syntax

BETAINV(probability,alpha,beta,[A],[B])

Copyable formulas

English Excel · en-US
=BETAINV(A7,2,3)
Turkish Excel · tr-TR
=BETATERS(A7;2;3)

Compatibility function for older workbooks.

Worked examples

Find the cutoff for a beta proportion at the given probability. The probability refers to the lower tail.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Probability
7 0.1
8 0.5
9 0.9
Case Formula Expected result
Record 1 =BETAINV(A7,2,3) 0.1425593167
Record 2 =BETAINV(A8,2,3) 0.3857275681
Record 3 =BETAINV(A9,2,3) 0.6795394163
Microsoft Excel reference