Expand Minimize

WorksheetFunction.Binom_Inv Method (Excel)

Returns the inverse of the individual term binomial distribution probability.

Version Added: Excel 2010

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

  • 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.

Community Additions

ADD
Show:
© 2014 Microsoft