Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Linear weighted regression

10,083 views
Skip to first unread message

oliver

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

I would like to perform a weighted linear regression. Does
anybody know about an add-in that is able to perform such
an analysis?

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

Thanks a lot for your help!!

oliver

Jerry W. Lewis

unread,
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

unread,
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__

unread,
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

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

I am very sorry for your unfriendly answer to Baylye.

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
Message has been deleted
0 new messages