这里找一下http://zhidao.baidu.com/question/63628204.html?si=2
标准方差的计算公式
=(∑x^2-(∑x)^2/n)/(n-1)
去掉最大值与最小值的平方和
=SUMSQ(A1:A100)-SUMSQ(MAX(A1:A100),MIN(A1:A100))
和的平方为
=POWER(SUM(A1:A100,-MAX(A1:A100),-MIN(A1:A100)),2)
n值为
=COUNT(A1:A100)-2
将上述公式合起来
=(SUMSQ(A1:A100)-SUMSQ(MAX(A1:A100),MIN(A1:A100))-POWER(SUM(A1:A100,-MAX(A1:A100),-MIN(A1:A100)),2)/(COUNT(A1:A100)-2))/(COUNT(A1:A100)-3)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024