calibration curve uncertainty...
Posted: Wed Aug 09, 2006 9:22 am
by n-cute
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
Posted: Wed Aug 09, 2006 4:00 pm
by DR
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.
Posted: Fri Aug 11, 2006 6:52 am
by n-cute
THX for Your help:) I'll try this method.
