Function Math Statistics Class

Standardize

Returns a normalized value from a distribution with mean vMean and standard deviation vStdDev.

Signature (Visual Basic / VBA)

Public Function Standardize( _
      ByVal vX As Variant _
    , ByVal vMean As Variant _
    , ByVal vStdDev As Variant _
    ) As Variant

Code Example

    Standardize(0.5, 0, 1) = .5
    Standardize(1.0, 0, 1) = 1
    Standardize(0.5, 3, 1) = -2.5
    Standardize(1.0, 3, 1) = -2
    Standardize(0.5, 3, 2) = -1.25
    Standardize(1.0, 3, 2) = -1

Parameters

Parameter Description
vX The numeric value to be normalized.
vMean Mean of the distribution.
vStdDev Standard deviation of the distribution.

Return Value

The normalized value from a distribution with mean vMean and standard deviation vStdDev.