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

BETAINV(probability, alpha, beta [,A] [,B])

 
 Returns the inverse of the cumulative beta probability density function.

 probabilityThe probability associated with the beta distribution.
 alphaThe parameter to the distribution.
 betaThe 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 "probability" = 0, then #NUM! is returned.
     
  		• If "probability" > 1, then #NUM! is returned.
     
  		• If "A" and "B" are left blank, then the standard cumulative beta distribution is used with A = 0 and B = 1.
     
  		• This function uses an iterative technique for calculating the function. Given a probability value, the function iterates until the result is accurate to within ±3x10-7.
     
  		• If the function does not converge after 100 iterations, then #N/A is returned.
     
  		• The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (828299).

     EXAMPLES
     
     A
    1=BETAINV(0.685470581,8,10,1,3) = 2
    2=BETAINV(0.2,1.5,4,1,2) = 1.112
    3=BETAINV(0.5,1,2,1,2) = 1.293
    4=BETAINV(0.5,1,-2,1,2) = #NUM!
    5=BETAINV(0,8,10,1,3) = #NUM!
    6=BETAINV(1,8,10,1,3) = #NUM!
    7=BETAINV("some text",8,10,1,3) = #VALUE!
    		 
     Functions - B | Index - B | Office Online 

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