BETA.INV

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

Returns the inverse of the cumulative probability function for a beta distribution.

probability	The probability associated with the distribution.
alpha	The parameter to the distribution.
beta	The parameter to the distribution.
A	(Optional) The lower bound to the interval of x.
B	(Optional) The upper bound to the interval of x.

REMARKS

* For an illustrated example refer to the page under Distributions
* The beta distribution is a continuous distribution
* If "A" is left blank, then 0 is used.
* If "B" is left blank, then 1 is used
* You can use the BETA.DIST function to return the probability distribution function OR the cumulative distribution function for a beta distribution.
* This function was added in Excel 2010 to replace the BETAINV function.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=BETA.INV(0.685470581, 8, 10, 1, 3) = 2
2	=BETA.INV(0.2, 1.5, 4, 1, 2) = 1.112
3	=BETA.INV(0.5, 1, 2, 1, 2) = 1.293
4	=BETA.INV(BETA.DIST(-2, 8, 10, TRUE, -5, 3), 8, 10, -5, 3) = -2
5	=BETA.INV(0.5, 1, -2, 1, 2) = #NUM!
6	=BETA.INV(0, 8, 10, 1, 3) = #NUM!
7	=BETA.INV(1, 8, 10, 1, 3) = #NUM!
8	=BETA.INV("some text", 8, 10, 1, 3) = #VALUE!