Weighted Linear Regression


D

Dave_AD

Excel does not do weighted linear regression within scatterplots. Is anyone
out there aware of any VBA that would allow the user to specify regression an
X range against a Y range using a Z range as the weighting range ? THanks for
any help in advance.
 
Ad

Advertisements

Joined
Jun 10, 2008
Messages
8
Reaction score
0
Dave,

You don't really need a code to do that. Simply set up your worksheet range to reflect the weights. For instance, if your data is as follows:

Y-range X-range Z-Range
y1 x1 z1
y2 x2 z2
y3 x3 z3
y4 x4 z4
... ... ...
yn xn zn

Recast as:

Y-range X-range
y1/z1 x1/zn
y2/z2 x2/z2
y3/z3 x3/z3
y4/z4 x4/z4
... ...
yn/zn xn/zn

Run normal regression (using VBA or otherwise) on the recast data.

HTH
 
Last edited:
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top