Difference between revisions of "Documentation/How Tos/Calc: B function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
m (Bot: Adding Category: Documentation)
Line 27: Line 27:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation]]

Revision as of 13:09, 20 November 2009


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.
The probability is calculated as:
Calc b equation.png (where k2 = k if k2 is omitted).

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.

Issues:

  • Excel does not have this function.


Template:Documentation/SeeAlso

Personal tools