WorksheetFunction.Standardize Method
Returns a normalized value from a distribution characterized by mean and standard_dev.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Standardize ( _
Arg1 As Double, _
Arg2 As Double, _
Arg3 As Double _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Double
Dim Arg3 As Double
Dim returnValue As Double
returnValue = instance.Standardize(Arg1, _
Arg2, Arg3)
double Standardize(
double Arg1,
double Arg2,
double Arg3
)
Parameters
Arg1
Type: System.DoubleX - the value you want to normalize.
Arg2
Type: System.DoubleMean - the arithmetic mean of the distribution.
Arg3
Type: System.DoubleStandard_dev - the standard deviation of the distribution.
Return Value
Type: System.Double
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
.jpg "Equation for the normalized value")