Application of bootstrap estimation in VBA for statistic analysis of proficiency testing
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.
Bootstrap methodVisual Basic for ApplicationsProficiency testingStatistic analysis
万方数据
维普
