Documentation/How Tos/Calc: B function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 04:54, 26 April 2008 by Drking (Talk | contribs)

Jump to: navigation, search


B

Calculates probabilities for a binomial distribution.

Syntax:

B(n; p; k; k2)

With n independent trials, each with a probability p of success, B returns the probability that the number of successes will be between k and k2 inclusive, or if k2 is omitted the probability that the number of successes will be exactly k.

Example:

B(10; 1/6; 2)

returns approximately 0.29 (29%), the probability that the number four will be thrown exactly twice in 10 throws of a die.

See also:

BINOMDIST

Statistical functions

Issues:

  • Excel does not have this function.
Personal tools