EXCEL程序在质量控制基础实验中的运用

用EXCEL2003软件优化计算实验室质量控制中的2个重要的质量控制基础实验,空白实验值的测定与检测限的确定,校准曲线的绘制与线性检验,充分利用软件中提供的函数功能及图表功能,方法简便,直观,可操作性强,具有快速、简便高效的特点,可以直接计算结果,能在线观测由输入数据变化而带来的结果变化,大大提高了分析工作的效率,最大限度避免手工操作引起的误算,减轻了分析人员的劳动。

In Excel Quality Control Procedures in The Use of Experimental Basis

Using software to optimize computing EXCEL2003 laboratory quality control of two important quality control experimenfal basis-blank experiments measured value with the limited testing, established calibration curve and the mapping of linear test, and making full use of software provided by the function of the functions and graphs functions, methods simple, intuitive, user-friendly, with a quick, simple and efficient features, the results could be directly calculated to online data entry changes brought about by observing the results of changes, which greatly improved the efficiency of the analytical work, manual operation to avoid miscalculation caused alleviate the labour analysts.