Documentation/Calc Functions/B

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

B

Category:

Statistical Analysis

Summary:

Returns the probability of a sample with binomial distribution.

Syntax:

B(Trials; SP; T1; T2)

Returns:

Arguments:

Trials is the number of independent trials.

SP is the probability of success on each trial.

T1 defines the lower limit for the number of trials.

T2 (optional) defines the upper limit for the number of trials.

Additional details:

Examples:

What is the probability with ten throws of the dice, that a six will come up exactly twice? The probability of a six (or any other number) is 1/6. The following formula combines these factors:

=B(10;1/6;2) returns a probability of 29%.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: