by
lmh » Mon May 02, 2011 5:30 pm
sometimes your chromatography software will do it for you. Note that some software will call it a s.d., some a S.E. (As I remember, Excel and Chemstation produce exactly the same value but call it different things). This is the Excel method:
In Excel, put your concentrations/amounts in one column, and your responses in another.
In a spare cell somewhere, enter the formula =linest(Yrange, Xrange, true, true)
where Yrange and Xrange are the ranges of cells containing your data
Select the cell, and four cells below it, and one column to the right
with these cells selected, click in the window where you type the formula
press ctrl-shift-enter. This turns the formula into an array-formula, and fills all the selected cells
Look up Excel's help on "linest" to find which one is the SE (sd) of the line.