Function Math Probability Class

NormalCDF

Normal Cumulative Distribution Function

Signature (Visual Basic / VBA)

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

Parameters

Parameter Description
vX Function returns Null if vX cannot be fixed up to a Double precision floating point number.
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.