Excel在电线电缆防白蚁性能测试中的应用

Application of Excel in calculating of Termite test for wires and cables

击倒法是国标GB2951．38—86电线电缆白蚁试验方法之一。本文介绍利用Excel编制统计分析的程序，科研人员只需要输入实验组数、击倒时间、试虫总数和击倒数，即可快速、准确得出KT50、KT95、线性回归方程和相关系数等计算结果，并可进行显著性检验并绘制出毒力曲线。该程序操作简便，数据精确，便于推广。

Based on the Chinese national standard GB2951.38--86, anti--termite performance tests of wire and cable commonly use membrane method. This article introduces a new data processing system. Researchers only need to input the number of the experimental group, knock time, the total number of insects and the knocked insects, and the results of KT50, KT95, linear regression equation, correlation coefficient and so on will be output quickly and accurately by the system, as well as the significance testing and toxicity curve. This accurate data processing system is easy to operate and promote.