LOD LOQ by Excel

Discussions about HPLC, CE, TLC, SFC, and other "liquid phase" separation techniques.

4 posts Page 1 of 1
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.
I made a quick recording using Excel 2000:
http://www.lcresources.com/sandbox/LOD-LOQ/LOD-LOQ.html
-- Tom Jupille
LC Resources / Separation Science Associates
tjupille@lcresources.com
+ 1 (925) 297-5374
Thank you very much Tom J,

It was really helpful,

I really appreciate your help.
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/
4 posts Page 1 of 1

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 1117 on Mon Jan 31, 2022 2:50 pm

Users browsing this forum: No registered users and 1 guest

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry