描述

STANDARDIZE函数从以均值和standard_dev为特征的分布返回归一化值。

语法

STANDARDIZE(x, mean, standard_dev)

争论

Argument 描述 Required/Optional
X The value you want to normalize. Required
Mean The arithmetic mean of the distribution. Required
Standard_dev The standard deviation of the distribution. Required

Notes

  • 归一化值的公式为-

    $$Z = \frac {X- \mu} {\sigma} $$

  • 如果standard_dev≤0,则STANDARDIZE返回#NUM!错误值。

  • 如果提供的任何参数都是非数值的,则STANDARDIZE返回#VALUE!错误值。

适用性

Excel 2007,Excel 2010,Excel 2013,Excel 2016

Example

Standardize Function

参考链接

https://www.learnfk.com/javascript/advanced-excel-statistical-standardize-function.html