Function Math Probability Class

NegativeBinomialPDF

Negative Binomial Probability Density Function

Signature (Visual Basic / VBA)

Public Function NegativeBinomialPDF( _
      ByVal vNumFail As Variant _
    , ByVal vNumSuccess As Variant _
    , ByVal vProbSuccess As Variant _
    ) As Variant

Parameters

Parameter Description
vNumFail Number of failures. Number is rounded to the nearest integer. Function returns Null if vNumFail is less than or equal to zero (<=0).
vNumSuccess Threshold number of successes. Number is truncated to the nearest integer. Function returns Null if vNumSuccess cannot be fixed up to a Double precision floating point number.
vProbSuccess Probability of success. Function returns Null if vProbSuccess is not between 0 and 1 inclusive.