# Documentation/Calc Functions/BINOMDIST

Jump to navigation Jump to search

BINOMDIST

## Category:

Statistical Analysis

## Summary:

Returns the individual term binomial distribution probability.

## Syntax:

BINOMDIST(X; Trials; SP; C)

## Returns:

Returns a real number which is either a probability or a sum of probabilities defined by the binomial distribution. The value ranges from 0 to 1, i.e. [0,1].

## Arguments:

X is a positive integer value or a reference to the cell containing that number which is the number of successes in a set of trials.

Trialsis a positive integer value or a reference to the cell containing that number which is the number of independent trials.

SP is a real number between 0 and 1(both inclusive) or a reference to the cell containing that value which is the probability of success on each trial.

C is a logical value that determines the form of the function. C = 0 or False to calculate the probability density function. It can be any other value like 1 or True to calculate the cumulative distribution function.

• If X and Trials are a non-integer value, then the function uses their floor value, i.e. they are truncated to an integer value.
• If X and Trials are less than zero then the function returns an error value. Also if X is greater than "Trials after truncation, then the function returns an error value.
• If SP is greater than 1 or less than 0, then the function returns an error value.

## Additional details:

• The formula for BINOMDIST for probability density function (when C=0)is:

where:

is COMBIN(n,x)

• The formula for BINOMDIST for the cumulative binomial distribution (when C=1) is:
• For more details on the binomial distribution, visit Wikipedia.

## Examples:

Formula Description Returns
=BINOMDIST(5;12;0.5;0) shows the probabilities for 12 flips of a coin that Heads will come up exactly the 5 number of times 0.193359375
=BINOMDIST(4;12;0.5;1) shows the cumulative probabilities for the same series. Here the cumulative probability of the series is 0, 1, 2, 3 or 4 times Heads (non-exclusive OR) 0.19384765625

BINOMDIST