Function Math Probability Class

NormalRandom

Random Number with Normal Distribution

Signature (Visual Basic / VBA)

Public Function NormalRandom( _
      Optional ByVal vMean As Variant = 0 _
    , Optional ByVal vStdDev As Variant = 1 _
    ) As Variant

Parameters

Parameter Description
vMean Mean of the distribution. Function returns Null if vMean cannot be fixed up to a Double precision floating point number. Argument defaults to a value of zero (0) if it is missing.
vStdDev Standard deviation of the distribution. Function returns Null if vStdDev is less than or equal to zero (<=0). Argument defaults to a value of one (1) if it is missing.