摘要
质量控制是全面质量管理体系中的重要组成部分,在质控中常使用一些统计学方法对实验数据进行归纳和分析,也常用一些图表对质控情况进行形象的显示。电子表格软件Excel具有强大的计算功能和图表功能,将其用于质控参数的统计分析可以大大提高工作效率。为此对Excel软件中用于质控参数计算的函数AVERAGE和STDEVP的概念和用法进行了介绍,并以ELISA法HIV抗体检测的质量控制为例,详细说明了Excel软件在实验室质量控制的参数统计和图表制作中的应用方法。
Qualiry control i.s an important part in the systems of the comprehensive quality management on laboratoy. Sevatiatic measuresare fretly adopted to induce and analyse the laboratory data on quality control; in addition, diagrams are also used to cisualize the situation of the quality control. The electronic form software Excel has a powerful function of calculation and diagram. It can improve the efficiency greatly to use Excel on the statistics and analysis of the parameter of the quality-control . This textintroduces the concept and usage of AVERAGE and STDEVP, the function of Excel being used on the parameter calculation of ality control. Taking the lily control of ELISA for HIV antibody inspection as an example, the text explicates the applications of Excel on the statistic parameter calculation and diagram creation ol the labory quality control.
出处
《中国国境卫生检疫杂志》
CAS
2001年第4期240-243,共5页
Chinese Journal of Frontier Health and Quarantine
关键词
EXCEL
实验室
质量控制
Excel statistic diagram laboratory quality control
