方差和标准差在excel

Question

具体操作如下：1 首先打开电脑上的Excel，输入所要计算的数据值；2 找到Excel右上角的【自动求和】点击它；3 下拉菜单点击【其他函数】；4

Answer 1

具体操作如下：
1.首先打开电脑上的Excel，输入所要计算的数据值；
/iknow-pic.cdn.bcebos.com/63d9f2d3572c11dff2dc48cb682762d0f603c2cd?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1" esrc="https://iknow-pic.cdn.bcebos.com/63d9f2d3572c11dff2dc48cb682762d0f603c2cd?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1" alt="方差和标准差在excel" />
2.找到Excel右上角的【自动求和】点击它；
/iknow-pic.cdn.bcebos.com/86d6277f9e2f07086381dde8e224b899a801f256?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1" esrc="https://iknow-pic.cdn.bcebos.com/86d6277f9e2f07086381dde8e224b899a801f256?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1" alt="方差和标准差在excel" />
3.下拉菜单点击【其他函数】；
/iknow-pic.cdn.bcebos.com/bba1cd11728b4710400c0b24c8cec3fdfc032333?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1" esrc="https://iknow-pic.cdn.bcebos.com/bba1cd11728b4710400c0b24c8cec3fdfc032333?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1" alt="方差和标准差在excel" />
4.在弹出的窗口里选择（方差）STDEV，标准差是（STDEVP），点击确定即可成功运算。
/iknow-pic.cdn.bcebos.com/7a899e510fb30f245b671aebc395d143ac4b035c?x-bce-process=image/resize,m_lfit,w_600,h_800,limit_1" esrc="https://iknow-pic.cdn.bcebos.com/7a899e510fb30f245b671aebc395d143ac4b035c?x-bce-process=image/resize,m_lfit,w_450,h_600,limit_1" alt="方差和标准差在excel" />