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.

Remarks

* Added in Excel 2010.
* This function replaces the BETAINV function.
* For the Microsoft documentation refer to support.office.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(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!

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