基于VBA编程的尧敦图绘制方法及其在能力验证中的应用

doi:10.13228/j.boyuan.issn1000-7571.011780

摘要
图/表
参考文献
相关文章 (15)

全文: PDF (987 KB) HTML (1 KB)
输出: BibTeX | EndNote (RIS)

摘要基于霍特林T²检验推导了ISO 13528标准的能力验证尧敦(Youden)椭圆数学模型,并推导了尧敦椭圆的画法。通过细分Z_X坐标轴的方式把该数学模型转化为Excel的计算模型,采用VBA编程绘制出z值为坐标轴的尧敦图,通过坐标转换可以绘制以测量结果为坐标轴的尧敦椭圆。在1个尧敦图中同时绘制出置信水平为95%和99%的置信椭圆,直观地显示出满意结果、存疑结果和不满意结果。结合尧敦图可以分析实验室结果偏离原因,指导实验室的整改。即使不采用VBA编程,在Excel 平台上直接采用细分坐标轴的方法绘制尧敦图,也能够减少大量的计算工作,提高了绘图的效率,可以促进尧敦图在能力验证数据统计分析中的应用。应用绘制方法绘制了不锈钢化学成分分析能力验证中磷元素的尧敦图,根据绘制的尧敦图并结合能力验证数据分析了不满意或有问题结果产生的原因。

	服务

	把本文推荐给朋友
	加入我的书架
	加入引用管理器
	E-mail Alert
	RSS
	作者相关文章
	王明海
	孙璧瑶
	黄明星
	侯伟

关键词 ：尧敦(Youden)图, 能力验证, 霍特林T²检验, VBA编程

Abstract：The mathematical model of Youden ellipse for proficiency testing of ISO 13528 standard was derived base on Hotelling′s T² test. Meanwhile, the drawing method of Youden ellipse was also proposed. This mathematical model was changed to the calculation model of Excel by subdividing Z_X axis. The Youden plot with axis of z-score was drew using VBA programming. Meanwhile, the Youden plot with axis of testing results was obtained by axis transformation. In the same Youden plot, the confidence ellipse with confidence levels of 95% and 99% were drawn out respectively to give a visual display of satisfactory results, questionable results and unsatisfactory results. The reasons for result deviation in laboratory could be analyzed by combining Youden plot to guide the remediation of laboratory. Even without VBA programming, the subdivided axis drawing method could be used to draw out Youden pot directly in Excel, which could reduce the calculation amount and improve the plotting efficiency. The method could facilitate the use of Youden plot in proficiency testing. The Youden ellipse of phosphorus in the proficiency testing of stainless steel chemical composition analysis was drawn by the proposed method. The reasons of unsatisfactory or problematic results were analyzed according to the Youden ellipse and results of proficiency testing.

Key words： Youden plot proficiency testing Hotelling T²test VBA programming

收稿日期: 2022-02-22

ZTFLH:

TP312

基金资助:中国工程科技知识中心建设项目(CKCEST-2022-1-13)

作者简介: 王明海(1976—),男,高级工程师,硕士,主要从事能力验证技术研究;E-mail:13810673159@139.com

引用本文:

王明海, 孙璧瑶, 黄明星, 侯伟. 基于VBA编程的尧敦图绘制方法及其在能力验证中的应用[J]. 冶金分析, 2022, 42(10): 89-93. WANG Minghai, SUN Biyao, HUANG Mingxing, HOU Wei. Drawing method for Youden plot by VBA programming and its application in proficiency testing. , 2022, 42(10): 89-93.

链接本文:

http://yjfx.chinamet.cn/CN/10.13228/j.boyuan.issn1000-7571.011780 或 http://yjfx.chinamet.cn/CN/Y2022/V42/I10/89

[1] International Standards Organization.ISO13528-2005(E)Statistical methods for use in proficiency testing by interlaboratory comparison[S].
[2] National Association of Testing Authorities,Australia. Guide to NATA proficiency testing 2004 version 1[S]. Australia:NATA,2004.
[3] 余卫华,谭谦,于录军,等.ISO13528与NATA能力验证尧敦图的统计模型比较[J].冶金分析,2013,33(12):74-81.
YU Weihua,TAN Qian,YU Lujun,et al.Comparison of statistical model of Youden plot for proficiency testing in ISO13528 and NATA[J].Metallurgical Analysis,2013,33(12):74-81.
[4] 刘志敏.测量统计标准及其在认可认证中的应用[M].北京:中国标准出版社,2001.
[5] 熊薇,葛宇.Youden 图在实验室能力验证中的应用及绘制方法[J].计量技术,2008(4):63-65.
XIONG Wei,GE Yu.The application of Youden plot in proficiency testing and its drawing method[J].Metro-logy Technology,2008(4):63-65
[6] 毛燕,赵立群,张宁,等.Origin 软件在能力验证数据报告图示制作上的应用[J].食品安全质量检测学报,2016,7(11):4569-4575.
MAO Yan,ZHAO Liqun,ZHANG Ning,et al.Application of origin software in drawing report graphical representation of proficiency testing data[J].Journal of Food Safety and Quality,2016,7(11):4569-4575.
[7] 王林波,杨美成,陈祝康,等.运用EXCEL软件制作Youden图的方法及Youden图在能力验证计划数据中统计中的应用[J].中国药事,2012,26(4):364-367.
WANG Linbo,YANG Meicheng,CHEN Zhukang,et al.A method of drawing Youden graph by EXCEL and the application of Youden graph in analysis of proficiency testing result[J].Chinese Pharmaceutical Affairs,2012,26(4):364-367.
[8] 鲍磊.Youden图画法分析及在Excel中的应用[J].物理测试,2016,34(3):1-5.
BAO Lei.Youden chart analysis and its application in Excel[J].Physics Examination and Testing,2016,34(3):1-5.
[9] 谭瀛,蒋知俭,郭晓伟.Hotelling T²检验与u检验、t检验之间的关系[J].中国卫生统计,2000,17(1):11-14.
TAN Ying,JIANG Zhijian,GUO Xiaowei.The relationship between Hotelling T² test and u or t test[J].Chinese Journal of Health Statistics,2000,17(1):11-14.