EXCEL在农药毒力测定中的应用.pdf

中国农学通报 2009,25(19):206-208 Chinese Agricultural Science Bulletin EXCEL 在农药毒力测定中的应用 1 2 2 刘 霞 ，路永贵 ，闫当萍 1 2 （延安大学生命科学学院，陕西延安716000 ；延安市植保植检站，陕西延安716000 ） 摘 要：根据机值分析法原理，利用EXCEL 编制了农药毒力测定数据处理程序。用户只需输入药剂剂 量（或浓度）、试验总虫数和死虫数，即可快速、准确地计算出毒力测定中毒力回归曲线、致死中量， 95%置信限，相关系数和卡平方值等数据，并可进行卡平方检验和毒力曲线的绘制。 关键词：EXCEL ；毒力测定；机值分析法；致死中量 中图分类号：Q968 文献标识码：A 论文编号：2009-1033 Application of EXCEL in Calculating of Toxicity for Pesticide Bioassay 1 2 2 Liu Xia , Lu Yonggui , Yan Dangping 1 ( College of Life Sciences, Yanan University, Yan ’an Shaanxi 716000; 2 Yan ’an Plant Protection and Quarantine Station, Yanan Shannxi 716000) Abstract: Based on the principle of probit analysis, the data processing system for pesticide bioassay was es⁃ tablished with EXCEL. After the user input the insecticide dosages(or concentrations), the trial number of over⁃ all insect and dead insects, the procedure will calculate the toxicological regression line(LD-P), median lethal 2 dosage(LD ), 95% fiducial limit of LD , relation coefficient(r), and chi square test(χ ) in the insecticide toxico⁃ 50 50 logical test quickly and accurately, moreover, also can calculate the chi square test and draw the toxicological