The BETA.INV function returns the inverse of the cumulative distribution function for a specified beta distribution.

BETA.INV takes 3 required arguments and 2 optional arguments:

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

#1)
Using the BETA.INV function:
#2)
The arguments for the BETA.INV function are:
Argument Required? Description
probability Required A probability associated with the beta distribution.
alpha Required A parameter of the distribution.
beta Required A parameter of the distribution.
A Optional A lower bound to the interval of x.
B Optional An upper bound to the interval of x.
#3)
A few more things:
If any argument is nonnumeric, 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

Summary

The BETA.INV function returns the inverse of the cumulative distribution function for a specified beta distribution.
comments powered by Disqus