Practice free

BETA.INV function

BETA.INV works backwards from a probability to the x value for a beta distribution. It is the inverse of BETA.DIST with its cumulative option set to TRUE.

Example

Read it as a sentence: find the value at which the cumulative beta probability reaches 0.6875, with alpha 2 and beta 3, which gives 0.5.

Practice this in the app

Syntax

BETA.INV(probability, alpha, beta, [A], [B])

Arguments in [square brackets] are optional.

probability (required)
Cumulative probability between 0 and 1.
alpha (required)
First shape parameter.
beta (required)
Second shape parameter.
A (optional)
Lower bound; default 0.
B (optional)
Upper bound; default 1.

Returns: The x value whose beta cumulative probability equals the given probability.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=BETA.INV(0.6875,2,3) 0.5 Working example
=BETA.INV("0.6875",2,3) 0.5 Text-number in first arg
=BETA.INV({0.6875,0.6875},2,3) 0.5 Array in first arg (lifts, spills)
=BETA.INV(0.5,2,3,1,5) 2.542910273 With bounds
=BETA.INV("abc",2,3) #VALUE! Non-numeric text in first arg
=BETA.INV(NA(),2,3) #N/A Error in first arg
=BETA.INV(0,2,3) #NUM! Probability 0
=BETA.INV(1,2,3) #NUM! Probability 1

Watch out for

  • Calculated by iteration, so extreme inputs may return #N/A.
  • Probability must be greater than 0 and at most 1.

Where it works

Excel
BETA.INV arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .