Calculation of LOD,LOQ using Microsoft EXCEL functions : 

Watched video again today. Really informative

this tutorial video helped me a lot. thank you so much.

This video is very helpful but I would like to know why standard error value is used for standard deviation. Kindly clarify.

tyvm for your clear explanation

Thank you for this important video. I have gone through other similar videos too. Now, I am confused whether we have to use ‘standard error’ (generated by excel) directly imagining as same as ‘standard deviation’ or we have to convert generated ‘standard error’ into ‘standard deviation’ by multiplication with square root of number of paired measurements used first. I would appreciate if anybody clarifies the above. Thanks.

Simple yet lucid illustration. Great work.

The best explanation on how to calculate LOD and LOQ I have ever seen. What if your x-axis is a logarithm value (Logx) what further calculation may you do to obtain x

Can you use Microsoft example of linear regression?

Perfect video thank you so much.

Great effort in simple manner.. thanks you sir.

Nice work. Thank you for your explanation

Exelente, muchas gracias

good informative video

Thanks, could you help for LoD determination from log(concentration)

Thanks for video. Why did you use standard error instead of standard deviation for LOD and LOQ calculation?

Thank you sir for such a nice lecture

very helpful thank for sharing this video

Thank you 💞💞

good stuff

Hello shouldn't we be converting all standard error values to standard deviation by multiplying by the square root of 5?

Sir very much clear elaboration, can I use the same method for finding lod of my competitive ELISA results???

EXCELLENT DEMONSTRATION

Hello.. i have the same case as your example above.. which one of LOD I can use?.. can i use from STEYX?.. I am sorry my english is not really good and maybe i missed some explanation..

Hi, thank you very much for the demo! I am just confused about the following: ICH mentioned using standard DEVIATION for calculating LOD and LOQ, but the LINEST function gives standard ERROR right? Why do we not have to convert the SE value to SD value by multiplying with sqrt(n)?

Sir, if I have peak current instead of area in y-axis then shall I go with same procedure or I should find the area of the current curve and then proceed with regression fitting?

Hello, first thanks you for this presentation. Really a great work. At the end you have 2 different results by using Y intercept SD or Residual SD of regression. So which one is the correct answer for the LOD and LOQ values ?

Sir why you used standard error instead of standard deviation? Is it correct?

I want to calculate LOD and LOQ in UV-Vis spectrometry, I would like to know when to use SD of Y intercept over Residual SD of regression. Thank you.

Thank you! I have 2 different results by using Y intercept SD or Residual SD of regression. What is the correct?

Sir lostly find lod based on concentration.

hello can I get the lod and loq files for learning purposes