BETADIST(x, alpha, beta [,A] [,B])

Returns the probability of getting less than or equal to a particular value in a beta distribution.

xThe number between A and B from the distribution.
alphaThe first parameter to the distribution.
betaThe second 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.DIST was added in Excel 2010 to replace this function.
* The beta distribution is a continuous distribution..
* This function only uses the cumulative probability 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 "x" < "A", then #NUM! is returned.
* If "x" > "B", then #NUM! is returned.
* If "A" = "B", then #NUM! is returned.
* If "A" is left blank, then A = 0.
* If "B" is left blank, then #NUM! is returned.
* In Excel 2010 the accuracy of this function was improved.
* For the Microsoft documentation refer to support.office.com

 A
1=BETADIST(2,8,10,1,3) = 0.685
2=BETADIST(-2,8,10,-5,3) = 0.282
3=BETADIST(3,1,1,2,3) = 1
4=BETADIST(3,1,1,,3) = 1
5=BETADIST(3,-1,1,2,2) = #NUM!
6=BETADIST(3,1,1,2,) = #NUM!
7=BETADIST(3,1,-1,2,2) = #NUM!
8=BETADIST(3,1,1,2,2) = #NUM!
9=BETADIST(3,1,1,2,"some text") = #VALUE!


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