WorksheetFunction.Binom_Inv Method (Excel)
Returns the inverse of the individual term binomial distribution probability.
Version Information
Version Added: Excel 2010
Syntax
expression .Binom_Inv(Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
Required |
Double |
Trials - the number of Bernoulli trials. |
Arg2 |
Required |
Double |
Probability_s - the probability of a success on each trial. |
Arg3 |
Required |
Double |
Alpha - the criterion value. |
Return Value
Double
Remarks
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.