excel方差函数公式excel

excel求标准方差的公式是什么这里找一下http://wenwen.sogou.com/z/q658745990.htm?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:A...