Function Math Probability Class

BinomialRandom

Random Number with Binomial Distribution

Signature (Visual Basic / VBA)

Public Function BinomialRandom( _
      ByVal vNumTrials As Variant _
    , ByVal vProbSuccess As Variant _
    ) As Variant

Parameters

Parameter Description
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.