Related Topics:
	Spreadsheet Math Functions Formulas Tab and Insert Function Data Entry Tips for Functions Function Wizard

CRITBINOM

Description: Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Syntax: CRITBINOM(Trials, Probability_S, Alpha)

• Trials is the number of Bernoulli trials.

• Probability_S is the probability of a success on each trial.

• Alpha is the criterion value.

Remarks:

• All arguments must be numerical.

• Trials must be an integer.

• Trials must be >= 0.

• Probability_S must be >= 0 and <= 1.

• Alpha must be > 0 and < 1.

Example:

• CRITBINOM(6,0.5,.75) = 4 [the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value]

© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link