Edit

Share via


WorksheetFunction.Standardize(Double, Double, Double) Method

Definition

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

public:
 double Standardize(double Arg1, double Arg2, double Arg3);
public double Standardize (double Arg1, double Arg2, double Arg3);
Public Function Standardize (Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double

Parameters

Arg1
Double

X - the value you want to normalize.

Arg2
Double

Mean - the arithmetic mean of the distribution.

Arg3
Double

Standard_dev - the standard deviation of the distribution.

Returns

Remarks

If standard_dev ≤ 0, Standardize returns the #NUM! error value.

The equation for the normalized value is:

Figure 1: Equation for the normalized value

Applies to