Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 120
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weighted Regression Engineer001 Excel Worksheet Functions 5 April 1st 09 10:45 PM
Linear Regression al boccia Excel Worksheet Functions 8 December 12th 08 09:40 PM
The multiple regression tool - linear or non-linear regression? Statistical interest Excel Discussion (Misc queries) 2 February 6th 08 11:01 PM
Linear Regression in Excel Bernard Liengme Excel Worksheet Functions 0 July 31st 07 08:29 PM
linear regression Jason - MR Excel Worksheet Functions 1 November 28th 05 07:51 PM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"