B function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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
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.
See Also
