【摘要】 用Microsoft Excel对RIA室内质量控制(IQC)中的多参数(高、中、低)质控血清数据进行全自动处理和全自动绘制室内质控图。在Microsoft Excel中:AVERAGE和STDEV分别自动计算出质控血清的x、s和CV%;应用PEARSON计算出各质控血清间相关系数(r);在图表自定义系列中引入原数据自动绘制质控图;应用逻辑判定给出质控判定,导出各质控参数的质控状态、出控时间和出控数据。4年来对RIA各项目的多参数室内质控图自动绘制、质控数据自动统计计算和质量控制判定准确无误,具有速度快、易操作,实现了RIA的IQC微机自动化管理,且适用于其他各种体外标记免疫分析的IQC。更多还原

【Abstract】 We did automatic data processing and diagram drawing of various parameters of RIA’s internal quality control(IQC)by the use of Microsoft Excel(ME).By use of AVERAGE and STDEV of ME,we got(x),s and CV%.With pearson,we got the serum quality control coefficients(r). Inputing the original data to diagram’s self-definition item,the diagram was drawn automatically.By the use of logic judging,we got the quality control judging results with the status,timing and data of various quality control parameters.For the past four years,the ME data processing and diagram drawing as well as quality control judging have been showed to be accurate,convenient and correct.It was quick and easy to manage and the automatic computer processing of RIA’s IQC was realized.Conclusion: the method is applicable to all types of RIA’s IQC.更多还原