Probability of a trial result using binomial distribution[1][2].
Syntax:
BINOM.DIST.RANGE( number of trials:Integer, probability of success:Number, number of successes:Integer, {, s2:Integer} )
Returns the probability of a trial result using binomial distribution given a number of trials and the probability of success (in [0,1]) for each trial, with a number of successes in trials.
If the optional s2 parameter is given, the probability that the number of successful trials falls between number of successes and s2 is returned.
Revisions:
This function was added in Fireworkz 2.00.