BETAINV(probability, alpha, beta [,A] [,B])

Returns the probability of getting greater than a particular value in a beta distribution.

probabilityThe probability associated with the distribution.
alphaThe parameter to the distribution.
betaThe 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

* BETA.INV was added in Excel 2010 to replace this function.
* If any of the arguments are not numeric, then #VALUE! is returned.
* If "alpha" = 0, then #NUM! is returned.
* If "beta" = 0, then #NUM! is returned.
* If "probability" = 0, then #NUM! is returned.
* If "probability" > 1, then #NUM! is returned.
* If "A" and "B" are left blank, then the standard cumulative beta distribution is used with A = 0 and B = 1.
* This function uses an iterative technique for calculating the function. Given a probability value, the function iterates until the result is accurate to within ±3x10-7.
* If the function does not converge after 100 iterations, then #N/A is returned.
* In Excel 2010 the accuracy of this function was improved.
* For the Microsoft documentation refer to support.office.com

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


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top