How to use BETA.INV Function in Excel

The Excel BETA.INV function calculates the inverse of the cumulative beta probability density function for a supplied probability. The Beta.Inv function is new to Excel 2010 and so is not available in earlier versions of Excel. However, the function is simply an updated version of the Betainv function, which is available in earlier versions of Excel.

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

The BETA.INV function syntax has the following arguments:

  • Probability     Required. A probability associated with the beta distribution.
  • Alpha     Required. A parameter of the distribution.
  • Beta     Required. A parameter the distribution.
  • A     Optional. A lower bound to the interval of x.
  • B     Optional. An upper bound to the interval of x.

Example: Let’s look at some Excel BETA.INV function examples and explore how to use the BETA.INV function as a worksheet function in Microsoft Excel:

Example 1:

BETA.INV Function - How to use BETA.INV Function in Excel

Syntax:  =BETA.INV(B1,B2,B3,B4,B5)

Result: 1.776506506

BETA.INV Function in Excel 2 - How to use BETA.INV Function in Excel

Example 2:

Beta Inverse function – BETA.INV, is supplied values from 0.1 to 0.9 on interval of 0.1 along with alpha value as 8, beta value as 9, [A] as 0 and [B] as 1

So the result will be

BETA.INV Function 1 - How to use BETA.INV Function in Excel

Inverse Cumulative Beta Distribution, calculated for alpha=8 and beta=9 by the BETA.INV function is shown in above table and the same is plotted below.

BETA.INV Function in Excel 3 - How to use BETA.INV Function in Excel

Note:

  • If any argument is non numeric, BETA.INV returns the #VALUE! error value.
  • If alpha ≤ 0 or beta ≤ 0, BETA.INV returns the #NUM! error value.
  • If probability ≤ 0 or probability > 1, BETA.INV returns the #NUM! error value.
  • If you omit values for A and B, BETA.INV uses the standard cumulative beta distribution, so that A = 0 and B = 1.
  • Given a value for probability, BETA.INV seeks that value x such that BETA.DIST(x, alpha, beta, A, B) = probability. Thus, the precision of BETA.INV depends on the precision of BETA.DIST.
READ:  How to use NORM.S.DIST Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *