标准误(英文:Standard Error)衡量对应样本统计量抽样误差大小的尺度。
计算方式如下:
1、计算如图数据的平均值和标准差,点击B9单元格,然后插入--公式--插入函数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d1160924ab18972b86a5bd37e0cd7b899f510aab?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选择average函数,点击数值1后面的带有箭头的按钮,如图:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8ad4b31c8701a18b0175afb2982f07082938feb5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、按鼠标左键拖动b1到b8,然后点击如图红色箭头所指按钮,点击确定,即得出平均值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/622762d0f703918f00d08037573d269758eec4ce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击B10单元格,然后选择插入--公式--插入函数,选择sum函数,拖动选择b1到b8数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2fdda3cc7cd98d10edd2b1cc273fb80e7aec90cd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、确定后即可得到数据之和。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/314e251f95cad1c88c2e41da793e6709c83d51b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、插入其他函数和此种方法基本相同,只是选择的函数不一样。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e7cd7b899e510fb3578dca6adf33c895d0430cb2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)