Excel在杀虫药物毒力测定中的应用方法

Application Method to Calculate Toxicological Test with Excel

根据机值分析法原则 ,讨论用Excel编制杀虫药物毒力测定中两种常规数据LC50 和KT50 计算程序的方法。该程序只需输入药物浓度、时间和死虫数 ,即可打印试验结果报告 ,是一种更为方便、迅速、易操作的计算工具 (可自行编制 ) ,既能筛选试验数据 ,又能最低限度地降低误差 ,其计算代数精度可达 10 - 7。

Based on the principle of Probit Analysis, we will discuss the calculating method using Excel for two ordinary data statistics, LC 50 and KT 50 , widely used in the toxicological test of insecticides using Microsoft Excel.The code will print out the analysis report after the user input the drug concentration, the time period and the number of dead insects. It can screen sample data, thus greatly reduces calculation errors, with a precision upto 10 -7 .