Proficiency testing is an efficient measure to improve laboratory ability and data reliability by evaluating the tech-nical level and the operation of the management system for participants.Currently,classical statistical method and robust sta-tistical method are mainly used for the statistical analysis of proficiency testing data,while bootstrap method is used for proficiency testing data that emerges unexpected distribution or small sample size.Excel,as a popular and fully functional office software,not only can carry out simple data processing and drawing,but also can use VBA programming to realize simulated sampling and statistical inference based on intensive calculations.Therefore,to proactively satisfy the application requirements of bootstrap estimation in the data analysis of proficiency testing,a calculation program of bootstrap method based on VBA is developed,and its reliability is verified using the example data in ISO 13528:2022.Simultaneously,the data of the participators submitted in previous proficiency testing is used as examples to introduce the handling of different types of proficiency testing data by the bootstrap method based on VBA in detail,which provides a technical reference for the reasonable application of bootstrap estimation in the statistical analysis of proficiency testing results.
关键词
自助法/VBA/能力验证/统计分析
Key words
Bootstrap method/Visual Basic for Applications/Proficiency testing/Statistic analysis
维普
万方数据