-
- Posts: 137
- Joined: Wed Oct 17, 2007 6:34 am
I am trying to reproduce a MassHunter calibration curve generated in Excel.
The curve is linear regression weighted using 1/SD^2, not forced through origin
I can easily reproduce the unweighted curve, by either plotting a scatter graph of the data and letting excel do the regression, or by manually calculating the regression slope myself.
How can I apply the weighting?
I know that excel does not have a function to fit a trendline using weighting. There may be an add-in around, but I don't want to use an automatic function - I want to learn and get a feel for how weighting works.
I want to apply the weighting manually to generate the new points, but I don't know what parameters to apply the weighting to.
Thanks