Page 1 of 1

LOD LOQ by Excel

Posted: Mon Jun 17, 2013 3:27 pm
by jiten.cu
I know this topic has been discussed here before.
I was reviewing old posts but could not figure out the correct way.

Can anyone please post step by step process of calculation LOD/ LOQ using Excel?

I am talking about how to use 3.3 (SD/S) formula in excel.

Re: LOD LOQ by Excel

Posted: Mon Jun 17, 2013 5:37 pm
by tom jupille
I made a quick recording using Excel 2000:
http://www.lcresources.com/sandbox/LOD-LOQ/LOD-LOQ.html

Re: LOD LOQ by Excel

Posted: Mon Jun 17, 2013 5:59 pm
by jiten.cu
Thank you very much Tom J,

It was really helpful,

I really appreciate your help.

Re: LOD LOQ by Excel

Posted: Wed Apr 22, 2020 4:10 pm
by Jane Raphel
For calculating LOD, LOQ using Excel sheet ,
You can use MS Excel Regression, formula : STYEX or LINEST

Detailed demo is given in the attached youtube video

https://youtu.be/Ii2Z3hqwRGM/