Application of EXCEL in homogeneity and stability evaluation of sample for proficiency testing
ZHANG Hong-yan1, WANG Lu2, HUA Zhen-yu1,WANG Xian1 ,LIU He-jiang1, WANG Cheng*1
1. Risk Assessment Laboratory for Agro-Products Quality and Safety Urumqi, Ministry of Agriculture,Institute of Quality Standards & Testing Technology for Agro-Products, Xinjiang Academy of Agricultural Sciences, Key Laboratory of Agro-products Quality and Safety of Xinjiang, Urumqi 830000, China; 2.Agro-Environmental Protection Institute Ministry of Agriculture,Tianjin 300191,China
Abstract：The evaluation of homogeneity and stability of sample was the important component in proficiency testing. According to CNAS-GL03 <Guidance on Evaluating the Homogeneity and Stability of Samples Used for Proficiency Testing>, the basic principle of homogeneity and stability evaluation of sample for proficiency testing was introduced. The homogeneity testing of butyl hydroxy anisole (BHA) in edible oil and the stability testing of copper in tea were used as examples. The use method of EXCEL "Data Analysis" tool in homogeneity and stability evaluation of sample for proficiency testing was described. The input of experimental data was realized to calculate the F value and t value in mathematical statistics. It could be seen from results that the data treatment results of EXCEL were consistent with the calculation results of examples. The homogeneity and stability evaluation of sample for proficiency testing could be conducted using the "Data Analysis "of EXCEL. The work efficiency and the accuracy of statistical result could be improved.
张红艳，王璐，华震宇，王贤，刘和疆，王成. EXCEL在能力验证样品均匀性和稳定性评价中的应用[J]. 冶金分析, 2015, 35(4): 77-81.
ZHANG Hong-yan, WANG Lu, HUA Zhen-yu,WANG Xian,LIU He-jiang, WANG Cheng. Application of EXCEL in homogeneity and stability evaluation of sample for proficiency testing. , 2015, 35(4): 77-81.
