I would like to perform a weighted linear regression. Does
anybody know about an add-in that is able to perform such
Unfortunately, the Data-Analysis-Add-In is only good for
Thanks a lot for your help!!
(handle x-data analogously). The slope of weighted linear regression is
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.