Weighted Linear Regression
 

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.
--
Dave_DD

Weighted Linear Regression
 

Dave,
The best way in alike cases is to google for the term. You would be able to
find for example:
http://www.adamslim.com/ModellingGui...gGuidesWLR.htm
Regards,
Petr Bezucha


"Dave_AD" wrote:

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.
--
Dave_DD