Excel求一组数据的标准方差的工式是肿么写的?

标准方差的计算公式=(∑x^2-(∑x)^2/n)/(n-1)

假设数据在A1:A100：去掉最大值与最小值的平方和=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)