毒力回归方程计算用表

毒力方程计算

抑制率校正抑制率浓度浓度对数菌落直径(mm)对照菌落直径-处理菌落直径%% #NUM!0.00#DIV/0!#DIV/0!

#NUM!0.00#DIV/0!#DIV/0!

#NUM!0.00#DIV/0!#DIV/0!

#NUM!0.00#DIV/0!#DIV/0!

#NUM!0.00#DIV/0!#DIV/0!

#NUM!0.00#DIV/0!#DIV/0!

CK0.00#DIV/0!

R#NUM!

Y=#DIV/0!+#DIV/0!X

lgLC50=#DIV/0!lgLC95=#DIV/0!#DIV/0! LC50=#DIV/0!SE=#DIV/0!0.05置信限#DIV/0! LC95=#DIV/0!

抑制率校正抑制率浓度浓度对数菌落直径(mm)对照菌落直径-处理菌落直径%% 500.00 2.69909.0066.0088.000.8800 250.00 2.397913.0062.0082.670.8267 100.00 2.000023.0052.0069.330.6933 50.00 1.699036.0039.0052.000.5200 10.00 1.000047.0028.0037.330.3733 5.000.699066.009.0012.000.1200

CK75.000.000.00

R0.9794

Y= 3.2894+ 1.0898X

lgLC50= 1.5697lgLC95= 3.0790 1.57 LC50=37.13SE=0.000.05置信限37.13 LC95=1199.56

校正死亡率机率植#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

#DIV/0!

#DIV/0!#DIV/0!

校正死亡率机率植1.1750 6.17500.9411 5.94110.5053 5.50530.0502 5.0502-0.3230 4.6770-1.1750

3.8250

1.57 37.13