Excel 2000 in a Nutshell

Name

BINOMDIST

Synopsis

You can use BINOMDIST to determine the probability of success for a specific number of trials, assuming certain key things hold. This type of probability is referred to as individual term binomial distribution probability. For example, you can use this function to determine the probability that one half of the 100 cars in the parking lot are red.

To Calculate

=BINOMDIST(Number_s, Trials, Probability_s, Cumulative)

All of the arguments are required for this function.

Number_s

This argument must be a positive numeric value that indicates the number of successes that you expect to achieve during the trials. If this numeric value is not an integer, it is truncated to an integer by the function. The value of this argument must be smaller than the value of the Trials argument. For example, to see if half the cars are red, the value of the function would be 50.

Trials

This argument must be a positive numeric value that indicates the number of trials that will be performed. If this numeric value is not an integer, it will be truncated to an integer by the function.

Probability_s

The Probability_s argument must be a decimal value between and 1 that indicates the probability of success on each trial. In the previously mentioned example, it would be the proportion of the red cars in the population.

Cumulative

This argument must be a logical value of TRUE or FALSE that indicates actual form of the function. If this argument is TRUE the BINOMDIST function determines the probability ...