B function
From Apache OpenOffice Wiki
< Documentation | How Tos
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
| < {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
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.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}
