WorksheetFunction.Standardize (Excel)

Returns a normalized value from a distribution characterized by mean and standard_dev.

If standard_dev ≤ 0, Standardize returns the #NUM! error value. The equation for the normalized value is

Standardize (Arg1, Arg2, Arg3)

Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblArg3 As Double: dblArg3 = 
Dim dblStandardize As Double
dblStandardize = WorksheetFunction.Standardize(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3)


Arg1, Arg2, Arg3

Arg1 (Double) - X - the value that you want to normalize.

Arg2 (Double) - Mean - the arithmetic mean of the distribution.

Arg3 (Double) - Standard_dev - the standard deviation of the distribution.