วีดีโอ

Thanks

Thanks for this, was very simple explanation

Thank you Sir for sharing. Short and simple video, with to the point explaination on the calculation part.

Could you please give difference between stdev and steyx?

I think that there is a mistake in the provided calculations. It was used standard error instead of standard deviation. So the obtained values of LOD and LOQ are too big. 24 ppm is obvious high value

Very good Video for starting. Attached a youtube video link which explains 3 Simple and latest MS Excel tools to calculate LOD, LOQ using regression, STYEX and LINEST functions th-cam.com/video/Ii2Z3hqwRGM/w-d-xo.html

Hi Rahul, do you have any reference paper for the calculation method you used in this video?

There is a question here: is it possible to measure the concentrations lower than LOQ or LOD? if not, why the first point of this calibration curve (con=4) is lower than the calculated LOD (conc=8.1147) or LOQ (24. 590)? is it something wrong?

So the calculated LOD and LOQ are higher than few of the lowest standards? Is that OK?

Very helpful well explained video. How to modify calculations when we do method validation by doing readings in triplicate

Thanks I have questions haw I can choose the concentration for calibration curve

hi, helpful video but how do I calculate the slope?

VERY HELPFUL

very helpful. Thanks

thanks

Thanks! Needed this.

thanks

care to explain why you use standard error instead of standard deviation when calculating LOD and LOQ

Thanks bro.. You made my day.. :)

Very helpful video, thanks!

Much helped to me. Thank u so much.

Excelent explanation, thank you so much

very good

Thank you so much!!!! <3

Thanks for the video, very helpful.

Thank you this video was very helpful for my college chem lab calculations.

Very helpful video.... Thanks dude :)

Thanks man, it was really helpful. The only confusion I have is in the end there was something like you were comparing. what exactly was that. Is one method giving lower value than the other

thank you for the video,

Great dear thank you very much for making the things so simple.

Great video!

useful method.

Great! thanks very much indded !!!!!!!!!!!! you are the best man !!!! Cheers from Brazil !

Very good and informative, it really helped me

Good one..The wife has done the best job...in the movie

Awesome Video … !

Mast hai. Lekin ye pata nahin chala ki Sonia kaun hai. Next episode mein jaroor batana :-)

what bout with blank conc of 0 and absorbance 0?should it include for steyx?

thank you so much. this video is of great help :)

fine

if the equation for LOD and LOQ are 3.3(SD/S) and 10(SD/S) respectively why did you use the standard error?

thank you so much !!

Why did you do LOD = STEYX/SLOPE *3.3 and not just 3?

If you have any questions regarding the concept of LOD using standard deviation (the real formula), please feel free to contact me. My id is shahanerahul84@yahoo.com

Friend, the content is a bit misleading. You have used "standard error" (by STEYX function) to calculate limit of detection. By your video it appears that you have not followed the real formula of Limit of detection. For limit of detection calculations, "standard deviation" has to be used and not "standard error". In your video on youtube, you have used "standard error" which is violating the definition of LOD. Please check friend, 'standard error" and "standard deviation" do not mean the same.

Thank you very much...lol You saved my life too..lol

A really really useful video! Thanks it helped a lot :) Was wondering if you had any references or papers that officially have the formula to calculating this particular way for LOQ?

@trulytania Thanks tania.. Where do you work??

@caspargrindcore Yes.. Excel should calculate it automatically for you.. You can try the formula (=RSQ(x,y)) for the correlation coefficient.. Please let me know if it helps..

This is very informative. I work with HPLC/MS/MS and will try this out soon. Thanks so much for putting it up. Looking forwards to more relevant 'excel tricks.' :)