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

CRITBINOM(trials, probability_s, alpha)

 
 Returns the smallest number which is the cumulative binomial distribution that is greater than a criterion value.

 trialsThe number of Bernoulli trials.
 probability_sThe probability of a success on each trial.
 alphaThe criterion value ??

 REMARKS
 
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• If "trials" is not an integer, it is truncated.
     
  		• If "trials" < 0, then #NUM! is returned.
     
  		• If "probability_s" is < 0, then #NUM! is returned.
     
  		• If "probability_s" > 1, then #NUM! is returned.
     
  		• If "alpha" <= 0, then #NUM! is returned.
     
  		• If "alpha" >= 1, then #NUM! is returned.
     
  		• The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (828117).

     EXAMPLES
     
     A
    1=CRITBINOM(6,0.5,0.75) = 4
    2=CRITBINOM(4,0.5,0.75) = 3
    3=CRITBINOM(4,0.5,0.9999) = 4
    4=CRITBINOM(4,0.5,0.0001) = 0
    5=CRITBINOM(4,0.5,-0.75) = #NUM!
    6=CRITBINOM(4,-0.5,0.75) = #NUM!
    		 
     Functions - C | Index - C | Office Online 

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