Hi everyone,

I conducted an acute toxicity test with Artemia. I have calculated the LC50 using both graphical evaluation (Mortality Rate vs. Log Concentration) and Probit Analysis with SPSS and Excel.

In SPSS, I was able to obtain the upper and lower bounds of the 95% confidence interval (CI) directly from the software. However, I am unable to calculate the 95% CI for LC50 in Excel. I tried to calculate using the intercept (b) and slope (a) of the upper and lower 95% confidence intervals in the equation Y=ax+b, by setting Y=5 (the probit value at 50%). I attached the picture of summary output from the regression analysis in Excel.

Could you please explain how to calculate it? I would like to compare the results between the two software programs.

Thank you for your kind support!

Best regards,

Similar questions and discussions