Chromatography Forum

Chromatography Forum is a public discussion group where you can post questions, news, or messages of interest to chromatographers everywhere, but you must be registered to participate (registration is FREE). If you are a registered user, please log in.
http://www.chromforum.org/

weighting factor for linear regression

http://www.chromforum.org/viewtopic.php?t=3631

Page 1 of 1

weighting factor for linear regression

Posted: Fri Mar 17, 2006 11:01 pm
by meillid
hi, ALL,

I am preparing a paper for pulication. Since the caliberation curve copyed from the Analyst Software is not clear. So I need to plot a caliberation curve (linear regression with a weighing factor of 1/x) using EXCEL, anybody know how to apply a weighing factor to a column of data? I couldn't find from the on-line help, is there a function to do it or how to do manual calculation? Thanks a milion.

Posted: Sat Mar 18, 2006 4:14 am
by james little
Looks fairly complicated, but apparently can be done..

see

http://www.biotechnicalservices.com/dow ... Poster.pdf

Regression

Posted: Sat Mar 18, 2006 1:49 pm
by sandip.gurav
Can U mail me ur e-mail id so that i can attach excel sheet for regression calculation.
My id is sandip.gurav@gmail.com

Posted: Mon Mar 20, 2006 9:37 pm
by Margaret Antler
In graduate school, I used the following Excel routine to perform weighted linear least squares.

Instructions are in the file.

http://mrflip.com/resources/ExcelFuncti ... quares.xls
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/