BETA.INV

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

Returns the inverse of the cumulative probability function for 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
* This function was added in Excel 2010 to replace the BETAINV function.
* 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 to return the probability distribution function OR the cumulative distribution function for a beta distribution.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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!


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