[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

BINOMDIST

Syntax:

BINOMDIST ( number-successes , number-trials , success-probability , cumulative-flag )

Description: Computes the individual term binomial distribution probability.

Mathematical Formula:

The binomial probability mass function is:

where:

is COMBIN(n,x).

The cumulative binomial distribution is:

Arguments:

Name

Type

Description

number-successes

number

The number of successes in number-trials, truncated to an integer.

number-trials

number

The number of independent trials, truncated to an integer.

success-probability 

number

The probability of success on each trial.

cumulative-flag

logical

Determines the form of the function. If TRUE, then the cumulative distribution function is returned, which is the probability that there are at most number-successes successes; if FALSE, the probability mass function is returned, which is the probability that there are number-successes successes.

 

Return Type and Value: number – The individual term binomial distribution probability.

However, if

number-successes < 0 or number-successes number-trials, #NUM! is returned.

success-probability < 0 or success-probability > 1, #NUM! is returned.

[Example:

BINOMDIST(6,10,0.5,FALSE) results in 0.205078125
BINOMDIST(6,10,0.5,TRUE) results in 0.828125

end example]