Documentation/Calc Functions/B

Function name:
B

Category:
Statistical Analysis

Summary:
Returns the probability of a trial result using the binomial distribution.

Syntax:
B(Trials; SP; T1 [; T2])

Returns:
Returns a real number which is the probability of a trial and hence it is between 0(inclusive) and 1(inclusive).

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 defines the upper limit for the number of trials.


 * T1 and T2 lies between 0 and the independent number of trials for the function,i.e. [0,Trials].
 * If Trials are a non-integer value, then the function truncates it to an integer.
 * If Trials, T1 or T2 are less than zero, then the function returns an error value.
 * If T1 is greater than T2, then the function returns an error value.
 * If T2 greater than (Trials + 1), 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:
For more details on Binomial distribution, visit Wikipedia.

Related LibreOffice functions:
BINOM.DIST

BINOMDIST

ODF standard:
None

Equivalent Excel functions:
None