WorksheetFunction.Binom_Inv Method

Returns the inverse of the individual term binomial distribution probability.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Binom_Inv ( _
    Arg1 As Double, _
    Arg2 As Double, _
    Arg3 As Double _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Double
Dim Arg3 As Double
Dim returnValue As Double

returnValue = instance.Binom_Inv(Arg1, _
    Arg2, Arg3)

double Binom_Inv(
    double Arg1,
    double Arg2,
    double Arg3
)

Parameters

• Arg1
  Type: System.Double

  Trials - the number of Bernoulli trials.

• Arg2
  Type: System.Double

  Probability_s - the probability of a success on each trial.

• Arg3
  Type: System.Double

  Alpha - the criterion value.

Return Value

Type: System.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.

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace