STANDARDIZE function

Velja za
SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint Foundation 2010 SharePoint Server 2010 Windows SharePoint Services 3.0

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

Syntax

STANDARDIZE(x,mean,standard_dev)

X  is the value you want to normalize.

Mean  is the arithmetic mean of the distribution.

Standard_dev  is the standard deviation of the distribution.

Remarks

  • If standard_dev ≤ 0, STANDARDIZE returns the #NUM! error value.
  • The equation for the normalized value is:
    Equation

Example

X Mean StdDev Formula Description (Result)
42 40 1.5 =STANDARDIZE([X],[Mean],[StdDev]) Normalized value of 42 for the specified arguments (1.333333)