| 成绩正态校验的VBA实现 |
| |
| 引用本文： | 李刚,薛彩侠.成绩正态校验的VBA实现[J].通化师范学院学报,2011,32(10):21-23. |
| |
| 作者姓名： | 李刚 薛彩侠 |
| |
| 作者单位： | 安徽电子信息职业技术学院,安徽蚌埠,233030 |
| |
| 基金项目： | 院级课题“创新”教育在《ProE产品设计》课程教学中探索与实践阶段性成果;项目 |
| |
| 摘 要： | 现有成绩分析管理系统中包含成绩正态分布校验功能,对教学的分析和评价具有至关重要的作用.在VBA的基础上,给出了峰度、偏度正态校验方法的实现过程,并且在校验前,借鉴经验采用均值等方法对成绩数据进行预处理,在正态校验前剔除掉不符合要求的数据,降低了计算量,提高了计算效率,得到较好的分析效果.
|
| 关 键 词： | 成绩分析 正态校验 VBA 峰度、偏度校验法 |
Realization of Score Normal Test Base on VBA |
| |
| LI Gang,XUE Cai-xia.Realization of Score Normal Test Base on VBA[J].Journal of Tonghua Teachers College,2011,32(10):21-23. |
| |
| Authors: | LI Gang XUE Cai-xia |
| |
| Institution: | LI Gang,XUE Cai-xia (Anhui Vocational College of Electronics & Information Technology,Bengbu,Anhui 233030,China) |
| |
| Abstract: | The score analysis system has normal test function,it is very crucial for analyzing and evaluating the teaching.Based on VBA,the realization process of normal test with kurtosis and skewness test are discussed,and before the test,learning from experiences,the data was pretreated using mean value method and so on,which weed out the unreasonable data before the test,reducing the calculation,improving the computational efficiency,getting a better effect. |
| |
| Keywords: | score analysis normal test VBA kurtosis and skewness test |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
