摘要
根据最小二乘法基本原理,介绍线性回归截距、斜率、输出量等标准差的计算方法,重点介绍利用Excel获取评定测量不确定度所需各个参数的4种方法,将其用于标准物质定值等测量结果不确定度的评定,简便、快捷。
Based on the basic principle of least square method,the calculation method of standard deviation such as linear regression intercept,slope,output,and so on was introduced. The four methods of obtaining the parameters needed to assess the uncertainty of measurement by using Excel were emphatically introduced. The method is simple, quick, it can be used for the evaluation of uncertainty of measurement results such as the standard substance rating.
引文
[1]计量测试与技术手册编辑委员会.计量测试技术手册(第13卷化学)[M].北京:中国计量出版社,1997.
[2]CNAS-GL29-2010标准物质标准样品定值的一般原则和统计方法[S].
[3]来雪梅,王雪萍,张海燕.实验数据的拟合及其不确定度表示[J].中北大学报(自然科学版),2009 30(5):481-484.
[4]兰海.利用Excel进行测量不确定度的计算[J].计量与测试技术,2010,37(11):50-54.
[5]CNAS-GL06-2011,化学领域不确定度评定指南[S].
[6]范巧成.Excel在测量不确定度评定中的应用[M].北京:中国计量出版社,2003:19-20.
[7]郭民之.概率统计与实验[M].北京:北京大学出版社,2012:60-64.