WorksheetFunction.Binom_Inv (Excel)

Returns the inverse of the individual term binomial distribution probability.

If trials, probability_s, or alpha is nonnumeric, the Binom_Inv method generates an error. If trials is not an integer, it is truncated. If trials < 0, the Binom_Inv method generates an error. If probability_s < 0 or probability_s > 1, the Binom_Inv method generates an error. If alpha < 0 or alpha > 1, the Binom_Inv method generates an error.

Binom_Inv (Arg1, Arg2, Arg3)

Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblArg3 As Double: dblArg3 = 
Dim dblBinom_Inv As Double
dblBinom_Inv = WorksheetFunction.Binom_Inv(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3)

Arguments

Arg1 (Double) - Trials - the number of Bernoulli trials.

Arg2 (Double) - Probability_s - the probability of a success on each trial.

Arg3 (Double) - Alpha - the criterion value.