#1   Report Post  
Posted to microsoft.public.excel.charting
Prba
 
Posts: n/a
Default Regression

Question:
I have 2 dataseries in a XY Scatter Chart. I want a one (common) regression
line for both series, not one for each series. Is that possible?
  #2   Report Post  
Posted to microsoft.public.excel.charting
James Silverton
 
Posts: n/a
Default Regression

Prba wrote on Fri, 24 Feb 2006 07:37:27 -0800:

P Question:
P I have 2 dataseries in a XY Scatter Chart. I want a one
P (common) regression line for both series, not one for each
P series. Is that possible?

I wonder why you would want that? Why not just combine the two
sets of data when calculating the regression or plotting a trend
line? If you really want the two separate series to be plotted
and not the combined one, you might use a background color for
the combination after adding the trendline.

James Silverton.

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
How do I perform multiple regression in Excel using two independe Freda Excel Worksheet Functions 2 November 29th 05 04:59 PM
regression swissforestry Excel Worksheet Functions 1 November 10th 05 11:59 PM
multiple regression September21 New Users to Excel 5 September 25th 05 11:48 PM
mutiple regression help happycow Excel Discussion (Misc queries) 1 July 30th 05 04:47 AM
Erroneous Regression on Residuals Scott Excel Discussion (Misc queries) 3 July 27th 05 01:53 AM


All times are GMT +1. The time now is 06:05 AM.

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

About Us

"It's about Microsoft Excel"