欢迎访问《中国农学通报》,

中国农学通报 ›› 2009, Vol. 25 ›› Issue (19): 206-208.

• 植物保护 农药 • 上一篇    下一篇

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

刘 霞1,路永贵2,闫当萍2   

  • 收稿日期:2009-05-14 修回日期:2009-06-14 出版日期:2009-10-05 发布日期:2009-10-05

Application of EXCEL in Calculating of Toxicity for Pesticide Bioassay

  • Received:2009-05-14 Revised:2009-06-14 Online:2009-10-05 Published:2009-10-05

摘要:

根据机值分析法原理,利用EXCEL编制了农药毒力测定数据处理程序。用户只需输入药剂剂量(或浓度)、试验总虫数和死虫数,即可快速、准确地计算出毒力测定中毒力回归曲线、致死中量,95%置信限,相关系数和卡平方值等数据,并可进行卡平方检验和毒力曲线的绘制。

关键词: 小麦品种, 小麦品种, 小偃22, 高产稳产, 适应性广, 更新换代品种

Abstract:

Based on the principle of Probit Analysis, the Data Processing System For Pesticide Bioassay was established with EXCEL. After the user input the insecticide dosages(or concentrations), the trial number of overall insect and dead insects, the procedure will calculate the toxicological regression line(LD-P), median lethal dosage(LD50), 95% fiducial limit of LD50, relation coefficient(r), and chi square test(χ2) in the insecticide toxicological test quickly and accurately, moreover, also can calculate the chi square test and draw the toxicological line.