Function Math Probability Class

BinomialInverse

Inverse Binomial Cumulative Probability Function

Signature (Visual Basic / VBA)

Public Function BinomialInverse( _
      ByVal vCriteria As Variant _
    , ByVal vNumTrials As Variant _
    , ByVal vProbSuccess As Variant _
    ) As Variant

Parameters

Parameter Description
vCriteria Function returns Null if vCriteria is not between 0 and 1 inclusive.
vNumTrials Number of trials. Number is rounded to the nearest integer. Function returns Null if vNumTrials is less than or equal to zero (<=0) or less than vNumSuccess.
vProbSuccess Function returns Null if vProbSuccess is not between 0 and 1 inclusive.