简单介绍了对测量值中异常数据进行判别与剔除的三种统计判别方法——3σ准则、格鲁布斯准则和Q检验方法的基本原理。并以高分子科学实验中的两个实例为代表,应Visual Basic for Applications(VBA)编写的程序模块,对测量值中异常数据的判别与剔除进行了详细讨论.
The elementary theory for detection and elimination of abnormal data in the process of data treatment and valuation, such as 3σ measurement, Grubbs rule and Q test, was briefly introduced, respectively. Three program modulus detecting and eliminating abnormal data were programmed by Visual Basic for Applications (VBA) which is attached to office software. In the end, two experimental examples of polymer science were presented, and the application of above program modulus was discussed in detail.