BETA.INV function in Excel

BETA.INV function in Excel calculates the inverse of the cumulative beta probability density function for a supplied probability.

Syntax of BETA.INV Function in Excel:

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

 

  • probability – The probability of the Beta distribution, for which you want to find the value of x
  • alpha -A parameter of the distribution (must be > 0).
  • beta -A parameter of the distribution (must be > 0).
  • [A]         -An optional argument with default value 0, which gives the lower bound of the interval of x.
  • [B] -An optional argument with default value 1, which gives the upper bound of the interval of x.

 

Example of BETA.INV Function in Excel:

Formula

BETA.INV function in Excel 1

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

So the result will be

Result:

BETA.INV function in Excel 2

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

BETA.INV function in Excel 3

previous BETA.INV function in Excel                                                                                                                next BETA.INV function in Excel