BETA.INV(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.

* This function was added in Excel 2010 to replace the BETAINV function.
* If "A" is left blank, then ??
* If "B" is left blank, then ??
* For the Microsoft documentation refer to
* For the Google documentation refer to

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(0.5,1,-2,1,2) = #NUM!
5=BETA.INV(0,8,10,1,3) = #NUM!
6=BETA.INV(1,8,10,1,3) = #NUM!
7=BETA.INV("some text",8,10,1,3) = #VALUE!

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