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.DoubleTrials - the number of Bernoulli trials.
Arg2
Type: System.DoubleProbability_s - the probability of a success on each trial.
Arg3
Type: System.DoubleAlpha - 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.