Expand Minimize

WorksheetFunction.Standardize Method (Excel)

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

expression .Standardize(Arg1, Arg2, Arg3)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

X - the value you want to normalize.

Arg2

Required

Double

Mean - the arithmetic mean of the distribution.

Arg3

Required

Double

Standard_dev - the standard deviation of the distribution.

Return Value

Double

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

  • The equation for the normalized value is: awfstand_ZA06051247

Show:
© 2014 Microsoft