成绩正态校验的VBA实现

Realization of Score Normal Test Base on VBA

现有成绩分析管理系统中包含成绩正态分布校验功能,对教学的分析和评价具有至关重要的作用.在VBA的基础上,给出了峰度、偏度正态校验方法的实现过程,并且在校验前,借鉴经验采用均值等方法对成绩数据进行预处理,在正态校验前剔除掉不符合要求的数据,降低了计算量,提高了计算效率,得到较好的分析效果.

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.