Related Function:

The BETA.INV function returns the inverse of the beta cumulative probability density function (BETA.DIST).

• This function was introduced in Excel 2010 and so is not available in earlier versions.
• BETA.INV replaces the BETAINV function included in earlier versions of Excel.

### Syntax

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

#### Arguments

Argument Description
probability Specifies the name of a parameter
alpha A parameter of the distribution – must be > 0
beta A parameter of the distribution – must be > 0
[A] Optional. A lower bound to the interval of x. If omitted, [A] defaults to a value of 0
[B] Optional. An upper bound to the interval of x. If omitted, [B] defaults to a value of 1

#### Examples

A B C D
1 Data Formula Result Notes
2 0.772751 Probability associated with beta distribution
3 7 Argument of the distribution
4 10 Argument of the distribution
5 1 Lower bound
6 3 Upper bound
7
8 Formula Result Notes
9 =BETA.INV(A2,A3,A4,A5,A6) 2 Inverse of the cumulative beta probability density function for the parameters above

Usage note: Beta distribution can be used in project planning to model probable completion times given an expected completion time and variability.

#### Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric
#NUM! Occurs if either:

 • the supplied probability value is ≤ 0 or ≥ 1 • the supplied [A] and [B] arguments are equal • the supplied alpha or the supplied beta argument is ≤ 0