Excel在尿氟检测结果计算中的应用点滴

目的利用计算机对检洲数据进行结果计算，便于数据的保存和核对，提高工作效率。方法用Excel中的图表向导功能制作检测工作曲线，求出回归方程；用函数CORREL求得相关系数；用函数P0wER对检测结果进行计算。结果形象直观显示工作曲线各点的离散程度，简化复杂繁琐的结果运算，随时修改录入有误的数据，保存图表和计算公式，再次实验可自动进行检测结果的计算。结论用Excel软件对尿囊检测结果计算，既方便直观，又能保存数据图形及公式，快速而准确，实用性强，值得推广和应用。

Application of Excel In Urine Fluorine Examination Result Computation

Objective Carries on the result computation to the examination data using the computer, convenient for the data preservation and the checkup, enhances the working efficiency. Methods Examination working curve was manufactured and regression equation was extracted with the graph guide of Excel; Correlation coefficient was obtained with CORREL; Computation to the examination result was carried on with POWER. Results Dispersion degree of each point on working curve was displayed directly. The complex result operation was simplified. The input errors Were revised as necessary. The graph and formula were preserved. The computation to the examination data was carried on automatically for the next time. Conclusion It＇ s convenient and intuitionistic to calculate the urine fluorine examination result with Excel, and it＇s fast and accurate to preserve data graph and formula.This method is practical, worth promoting and applicating.