# Linear weighted regression

9215 views

### oliver

Jan 7, 2004, 5:17:10 AM1/7/04
to
Hi all,

I would like to perform a weighted linear regression. Does
an analysis?

Unfortunately, the Data-Analysis-Add-In is only good for
unweighted regressions.

Thanks a lot for your help!!

oliver

### Jerry W. Lewis

Jan 7, 2004, 9:04:00 AM1/7/04
to
Calculate a weighted average by

=SUMPRODUCT(<y-data>,<weights>)/SUM(<weights>)

(handle x-data analogously). The slope of weighted linear regression is
then

=SUMPRODUCT(<y-data>-<y-wtd_ave>,<x-data>-<x-wtd_ave>,<weights>) /
SUMPRODUCT((<x-data>-<x-wtd_ave>)^2,<weights>)

and the intercept of weighted linear regression is

=<y-wtd_ave> - <x-wtd_ave>*<wtd_slope>

These should work if there is no missing data. With missing data, you
must insure that the averages do not include unmatched data.

Jerry

### boxa...@g.cofc.edu

Mar 6, 2017, 1:49:22 PM3/6/17
to
Hi Jerry,

If I want to do a linear regression with 1/x weighting, how do I calculate the weights for the X data and Y data?

Thanks,

Baylye

### Auric__

Mar 6, 2017, 2:52:04 PM3/6/17
to
You start by not replying to a post that's ***THIRTEEN*** FUCKING YEARS OLD!

--
- I'm not brave. I'm just too tired and hungry and angry to care anymore.
- Perhaps they are not mutually exclusive. Perhaps bravery is simply apathy
with delusions of grandeur.

### Jambo Frigerio

Jan 10, 2021, 11:13:27 AM1/10/21
to
Dear Auric,

Weighted linear regression is still a widely used approach in analytical chemistry and maybe in other fields.

No matter if the post is 13, or 50, or 100 years old!

Baylye's question was very interesting and an answer to it would benefit other interested people.

Best regards,
Gianfranco