One regression line

P

Prba

Hi,
I have two series but I want one (common) regression line for both, not one
for each. Is that possible?
 
B

B. R.Ramachandran

Hi,

In two helper columns, copy the x- and y- data of the first data-set; now
copy the second data-set and paste it below the first data-set in those
helper columns. Make an xy-scatter plot for the combined data (helper
columns) and obtain the trendline.

If you prefer to have the two sets plotted as separate series, maybe for
other purposes, format Series 1 (the combined series) with "None" for "Line"
and "None" for "Marker" (This action would hide the data-points in the
combined plot), and add two more series using the original data.

Regards,
B. R. Ramachandran
 

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

Similar Threads

Automatic Regressions based on Field Values 0
Regression - trend line vs. data points?? 1
Regression - Data Labels on Chart 4
Regression 2
How to draw a regression line on 7000+ dated data with Excel 2007 2
Have 4 email addresses Want to auto forward all in one of them 0
Multiple Regression - polynomial fit 2
Multiple (as in many) regressions 3

Top