Difference between revisions of "Documentation/How Tos/Calc: B function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
| Line 15: | Line 15: | ||
<tt>'''B(10; 1/6; 2) '''</tt> | <tt>'''B(10; 1/6; 2) '''</tt> | ||
: returns approximately 0.29 (29%), the probability that the number four will be thrown exactly twice in 10 throws of a die. | : 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. | ||
| + | |||
{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||
| Line 23: | 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]]}} | ||
| − | |||
| − | |||
| − | |||
Revision as of 09:20, 2 March 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:
-
(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.
