Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > BETADIST
 

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

 
 Returns the cumulative beta probability density function.

 xThe value between A and B at which to evaluate the function.
 alphaThe first parameter to the distribution.
 betaThe second parameter to the distribution.
 AThe lower bound to the interval of x.
 BThe upper bound to the interval of x.

 REMARKS
 
  		• 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 ??
     
  		• If "A" and "B" are left blank, then the standard cumulative beta distribution is used with A = 0 and B = 1.
     
  		• If "B" is left blank, then #NUM! is returned.

     EXAMPLES
     
     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!
    		 
     Functions - B | Index - B | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top