登陆题目详情
单选题 Excel中用来计算样本方差的函数公式为( )
学科：2023－2024－1生技试验设计与统计分析
时间：2023-11-09 14:58:47
相关题目
相关作业
题目1单选题
比较大学生和幼儿园孩子身高的变异度,应采用的指标是( )A. 标准差B. 变异系数C. 极差D. 平均数
题目2单选题
Excel中用来计算样本方差的函数公式为( )A. AVERAGE()B. VARP()C. VAR()D. STDEVP()
题目3单选题
Excel中用来计算总体标准差的函数公式为( )A. STDEVP()B. STDEV()C. VARP()D. VAR()
题目4单选题
已知有一组数据:21,20,20,21,23,22,22,22,21,22,20,23,22,23,22,19,22,23,24,22,19,22,21,21,21,22,22,24,22,21,22,21,22,23,22,22,21,22,22,23,22,23,22,22,22,23,23,22,21,22,则该组数据的极差为( )A. 3B. 4C. 5D. 6
题目5单选题
已知有一组数据:21,20,20,21,23,22,22,22,21,22,20,23,22,23,22,19,22,23,24,22,19,22,21,21,21,22,22,24,22,21,22,21,22,23,22,22,21,22,22,23,22,23,22,22,22,23,23,22,21,22,试用Excel求其样本方差为( )A. 1.13B. 2.13C. 3.13D. 4.13
题目6单选题
已知有一组数据:21,20,20,21,23,22,22,22,21,22,20,23,22,23,22,19,22,23,24,22,19,22,21,21,21,22,22,24,22,21,22,21,22,23,22,22,21,22,22,23,22,23,22,22,22,23,23,22,21,22,试用Excel求其标准差为( )A. 1.063B. 1.459C. 1.769D. 2.032
题目7单选题
下列选项中,关于样本变异系数的计算公式正确的是( )A. <img src="https://tihai-oss-cloud.itihey.com/img/85892233503400d98c22a1c44718828d.png">B. <img src="https://tihai-oss-cloud.itihey.com/img/bcaa395e2be1fb17759ff941edd0de93.png">C. <img src="https://tihai-oss-cloud.itihey.com/img/38fbc632c9fa9c1569d1706c0810c019.png">D. <img src="https://tihai-oss-cloud.itihey.com/img/23b5da3ed0c96bf73399679262f04715.png">
题目8多选题
下列选项中,关于样本方差的计算公式正确的是( )A. <img src="https://tihai-oss-cloud.itihey.com/img/fc8a891d6f7e74c187ae3471d6e45767.png">B. <img src="https://tihai-oss-cloud.itihey.com/img/bce2feef9ad9d7b243c946d3fb13b4f2.png">C. <img src="https://tihai-oss-cloud.itihey.com/img/2fe763457c51472b1091d6af5bb357ca.png">D. <img src="https://tihai-oss-cloud.itihey.com/img/0146369d8346b68a0dc0c3911f1e7930.png">E. <img src="https://tihai-oss-cloud.itihey.com/img/cba5d85cb4252e8c50d245fd51ab3f44.png">F. <img src="https://tihai-oss-cloud.itihey.com/img/414d85f3bf3165e30f56ba0205e096c3.png">G. <img src="https://tihai-oss-cloud.itihey.com/img/db4245272edf0c7d21c0010d75ae77f1.png">
题目9单选题
对于记名证券而言,完成了清算和交收,还要完成一个( )环节,证券交易过程才告结束A. 余额清算B. 登记过户C. 清户D. 清账销户
题目10单选题
按( )划分,证券账户可以划分为上海证券账户和深圳证券账户A. 交易金额B. 交易场所C. 账户用途D. 投资者种类
下载 题海APP
拍照搜题更快捷
- 海量题库
- 无搜索限制
- 快捷拍照搜题
