-
- Posts: 686
- Joined: Mon Apr 29, 2013 4:37 pm
- Location: 39° 44' 44" N / 75° 32' 48" W
Please, can anyone describe how one could modify the calculation of linear regression, using a program like Excel for example, to employ weighting factors to variables being correlated? Quite often, software such as ChemStation, Chromeleon, Empower, TotalChrom and other CDS programs calculate fittings for us, but I find that folks ask me if I can provide them with a way to "check" the work of the CDS.
I understand that some of these CDSs are validated by their manufacturers, however that does not stop others from posing the question. I recall that John Dolan wrote a nice column in LC-GC North America back in 2004 or so concerning how/when to apply weighting to linear least squares (and also provided a nice reference within that column), but the math eludes me and I've not seen it explained in a fashion understandable to me anywhere.
I have heard "through the grapevine" of a text edited by Stavros Kromidas and Hans -Joachim Kuss titled "Quantification in LC and GC" that might help to answer my question...does anyone know about this text? Hard decision to plop down $150 for me these days kind of "in the dark," so-to-speak.
My thanks to you all, in advance.