Difference between revisions of "Documentation/How Tos/Calc: B function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Issues) |
(→Syntax:) |
||
| Line 8: | Line 8: | ||
: With <tt>'''n'''</tt> independent trials, each with a probability <tt>'''p'''</tt> of success, <tt>'''B'''</tt> returns the probability that the number of successes will be between <tt>'''k'''</tt> and <tt>'''k2'''</tt> inclusive, or if <tt>'''k2'''</tt> is omitted the probability that the number of successes will be exactly <tt>'''k'''</tt>. | : With <tt>'''n'''</tt> independent trials, each with a probability <tt>'''p'''</tt> of success, <tt>'''B'''</tt> returns the probability that the number of successes will be between <tt>'''k'''</tt> and <tt>'''k2'''</tt> inclusive, or if <tt>'''k2'''</tt> is omitted the probability that the number of successes will be exactly <tt>'''k'''</tt>. | ||
| + | |||
| + | : The probability is calculated as: | ||
| + | :: [[Image:Calc_b_equation.png]] (where <tt>'''k2'''</tt> = <tt>'''k'''</tt> if <tt>'''k2'''</tt> is omitted). | ||
=== Example: === | === Example: === | ||
Revision as of 05:04, 26 April 2008
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:
-
(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.
See also:
Issues:
- Excel does not have this function.
