<< Click to Display Table of Contents >> B (compatibility function) |
Syntax:
B(n, p, k1 [, k2])
where:
n is the number of independent trial runs.
p is the probability of success for each trial run (0 to 100%). The value must be > 0 and < 1.
k1 is the lower limit for the number of successes.
k2 (optional) is the upper limit for the number of successes.
Description:
This returns the probability of obtaining exactly k1 successes or between k1 and k2 successes in a binomial experiment with n independent trials.
Note:
This function was retained only for compatibility with PlanMaker 97. We recommend that you use the following Excel-compatible function instead:
B(n, p, k1) equals BINOMDIST(k1, n, p, FALSE) or BINOM.DIST(k1, n, p, FALSE)
B(n, p, k1, k2) equals BINOM.DIST.RANGE(n, p, k1, k2)
Compatibility notes:
This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.
In Excel 2013, a function identical to the B function was introduced: BINOM.DIST.RANGE. PlanMaker also supports this function. However, please bear in mind that older versions of Excel (and PlanMaker) do not know this function.
See also: