Documentation/Calc Functions/BINOMDIST

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

BINOMDIST

Category:

Statistical Analysis

Summary:

Returns the individual term binomial distribution probability.

Syntax:

BINOMDIST(X; Trials; SP; C)

Returns:

Arguments:

X is the number of successes in a set of trials.

Trials is the number of independent trials.

SP is the probability of success on each trial.

C = 0 calculates the probability of a single event and C = 1 calculates the cumulative probability.

Additional details:

Examples:

=BINOMDIST(A1;12;0.5;0) shows (if the values 0 to 12 are entered in A1) the probabilities for 12 flips of a coin that Heads will come up exactly the number of times entered in A1.

=BINOMDIST(A1;12;0.5;1) shows the cumulative probabilities for the same series. For example, if A1 = 4, the cumulative probability of the series is 0, 1, 2, 3 or 4 times Heads (non-exclusive OR).

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: