BINOM.INV

Returns the inverse of the binomial distribution[1][2].

Syntax:

BINOM.INV( number of trials:Integer, probability of success:Number, alpha:Number )

Returns the lowest value in the cumulative distribution function for the binomial distribution with number of trials and the probability of success (in [0..1]) for each trial that is greater than or equal to the given probability alpha (in [0..1]).

Revisions:

This function was added in Fireworkz 2.00.

  1. Weisstein, Eric W. "Binomial Distribution." From MathWorld--A Wolfram Web Resource. https://mathworld.wolfram.com/BinomialDistribution.html
  2. "Binomial Distribution." Chapter V, Section G, Online Statistics Education: A Multimedia Course of Study (http://onlinestatbook.com/). Project Leader: David M. Lane, Rice University.