-
- Posts: 26
- Joined: Mon Jul 17, 2006 8:39 am
Advertisement
calibration curve uncertainty...
Discussions about HPLC, CE, TLC, SFC, and other "liquid phase" separation techniques.
3 posts
Page 1 of 1
I'm trying to estimate uncertainty, but I stuck at calibration curve...
does anybody of You know, how to calculate "calibration uncertainty" using MS Exel? THX in Advance
-
- Posts: 2175
- Joined: Tue Aug 17, 2004 7:59 pm
The Linest function will give you linear regression data.
Select a 2 column by 4 row range, type "=linest" ( then select your Ys (column of areas), enter a "," then select your Xs (corresponding concentrations), add ",true,true)" and then hit control, shift, enter together (it's an array function).
This will give you slope, std error n, r² and F in the left column and y-intercept, std error n-1, std error y and df in the right column.
Select a 2 column by 4 row range, type "=linest" ( then select your Ys (column of areas), enter a "," then select your Xs (corresponding concentrations), add ",true,true)" and then hit control, shift, enter together (it's an array function).
This will give you slope, std error n, r² and F in the left column and y-intercept, std error n-1, std error y and df in the right column.
Thanks,
DR

DR

-
- Posts: 26
- Joined: Mon Jul 17, 2006 8:39 am
THX for Your help:) I'll try this method.
3 posts
Page 1 of 1
Who is online
In total there are 21 users online :: 0 registered, 0 hidden and 21 guests (based on users active over the past 5 minutes)
Most users ever online was 4374 on Fri Oct 03, 2025 12:41 am
Users browsing this forum: No registered users and 21 guests
Most users ever online was 4374 on Fri Oct 03, 2025 12:41 am
Users browsing this forum: No registered users and 21 guests
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.
- Follow us on Twitter: @Sep_Science
- Follow us on Linkedin: Separation Science
