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.