CRITBINOM

CRITBINOM(trials, probability_s, alpha)

Returns the inverse of the probability distribution function for a binomial distribution (renamed).

trials	The number of independent trials.
probability_s	The probability of a success on each trial.
alpha	The probability for the criteria.

REMARKS

* This function is only available for backwards compatibility and should not be used.
* BINOM.INV was added in Excel 2010 to replace this function.
* The binomial distribution is a discrete distribution
* This function assumes a cumulative probability function
* If "trials" < 0, then #NUM! is returned.
* If "trials" is not an integer, it is truncated.
* If "trials" is not numeric m then #VALUE! is returned.
* If "probability_s" < 0, then #NUM! is returned.
* If "probability_s" > 1, then #NUM! is returned.
* If "probability" is not numeric, then #VALUE! is returned.
* If "alpha" <= 0, then #NUM! is returned.
* If "alpha" >= 1, then #NUM! is returned.
* If "alpha" is not numeric, then #VALUE! is returned.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=CRITBINOM(6, 0.5, 9.38%) = 1.00
2	=CRITBINOM(6, 0.5, 23.44%) = 2.00
3	=CRITBINOM(6, 0.5, BINOMDIST(3, 6, 0.5, FALSE)) = 2.00
4	=CRITBINOM(6, 0.5, BINOMDIST(3, 6, 0.5, TRUE)) = 3.00
5	=CRITBINOM(6, 0.5, 0.75) = 4.00
6	=CRITBINOM(4, 0.5, 0.75) = 3.00
7	=CRITBINOM(4, 0.5, 0.9999) = 4.00
8	=CRITBINOM(4, 0.5, 0.0001) = 0.00
9	=CRITBINOM(4, 0.5, -0.75) = #NUM!
10	=CRITBINOM(4, -0.5, 0.75) = #NUM!