Bespoke Microsoft Office Development 
 Consultancy|

Excel

|Word|PowerPoint|Outlook|VBA|Tools|Newsletter 
 Excel > Functions > Statistical > BINOMDIST

 

BINOMDIST(number_s, trials, probability_s, cumulative)

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

 number_sThe number of successes out of the "trials".
 trialsThe number of independent trials.
 probability_sThe probability of a success on each trial.
 cumulativeThe type of function to use:
True = cumulative probability function (less than)
False = probability mass function (equal to)

 REMARKS
 
  • BINOM.DIST was added in 2010 to replace this function.
  •  
  • The binomial distribution is a discrete distribution.
  •  
  • If "cumulative" = True (or not zero), then the area under the curve to the left of "x" is returned. This uses the cumulative probability function.
  •  
  • If "cumulative" = False (or zero), then the height of the bell shaped curve at "x" is returned. This uses the probability mass function.
  •  
  • The "number_s" and "trials" are truncated to integers.
  •  
  • If "number_s" is not numeric, then #VALUE! is returned.
  •  
  • If "number_s" < 0, then #NUM! is returned.
  •  
  • If "number_s" > "trials", then #NUM! is returned.
  •  
  • If "trials" is not numeric, then #VALUE! is returned.
  •  
  • If "probability_s" < 0, then #NUM! is returned.
  •  
  • If "probability_s" > 1, then #NUM! is returned.
  •  
  • If "probability_s" is not numeric, then #VALUE! is returned.
  •  
  • In Excel 2010 the accuracy of this function was improved.
  •  
  • In Excel 2003 the accuracy of this function was improved Knowledge Base Article (827459).
  •  
  • Example 1 -
  •  
  • Example 2 -

  •  EXAMPLES
     
     A
    1=BINOMDIST(1,6,0.5,FALSE) = 9.38%
    2=BINOMDIST(2,6,0.5,FALSE) = 23.44%
    3=BINOMDIST(3,6,0.5,FALSE) = 31.25%
    4=BINOMDIST(4,6,0.5,FALSE) = 23.44%
    5=BINOMDIST(5,6,0.5,FALSE) = 9.38%
    6=BINOMDIST(6,6,0.5,FALSE) = 1.56%
    7=BINOMDIST(1,6,0.5,TRUE) = 10.94%
    8=BINOMDIST(2,6,0.5,TRUE) = 34.38%
    9=BINOMDIST(3,6,0.5,TRUE) = 65.63%
    10=BINOMDIST(4,6,0.5,TRUE) = 89.06%
    11=BINOMDIST(5,6,0.5,TRUE) = 98.44%
    12=BINOMDIST(6,6,0.5,TRUE) = 100.00%
    13=BINOMDIST(6,10,-0.5,FALSE) = #NUM!
    14=BINOMDIST(6,"some text",0.5,FALSE) = #VALUE!
     

     Functions - B | Index - B | Office Online 2010 | 2007 | 2003 

     © Better Solutions Limited 17-Jul-2014Top