Public Function Standardize( _
ByVal vX As Variant _
, ByVal vMean As Variant _
, ByVal vStdDev As Variant _
) As Variant 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) = -1See also: NormalCDF Function
NormalPDF Function
NormalInverse Function
ZTst Function
MathProbability Class
STANDARDIZE Function (Microsoft Excel)vX: The numeric value to be normalized. Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.