Spread 8.0 Documentation
BINOMDIST
Support Options
Formula Reference > Built-In Functions > BINOMDIST

Glossary Item Box

BINOMDIST


Name

Binomial distribution

Description

Calculates the individual term binomial distribution probability.

Syntax

BINOMDIST(x,n,p,cumulative)

Argument Description
x Number representing the number of successes in trials; if not an integer, the number is truncated
n Number representing the number of independent trials; if not an integer, the number is truncated
p Probability of success on each trial; number between 0 and 1
cumulative Logical value that determines the form of the function; if TRUE, then this function returns the cumulative distribution function, which is the probability that there are at most x successes; if FALSE, it returns the probability mass function, which is the probability that there are x successes

Remarks

Use this function in problems with a fixed number of tests or trials, when there are two mutually exclusive possible outcomes (a "success" and a "failure"), when trials are independent, and when the probability of one outcome is constant throughout the experiment. This function can, for example, calculate the probability that two of the next three babies born are male.

The binomial probability mass function is calculated as follows:

The cumulative binomial distribution is calculated as follows:Data Type

Accepts numeric data for all arguments, except cumulative, which accepts logical data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

BINOMDIST(5,10,0.5,FALSE)=0.2460937500

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.