Need multiple regression line on a scatter plot

hansdecocq

New Member
Joined
Jan 17, 2011
Messages
13
Hello

I'm able to produce a proper scatter plot
I manage to put the regression line on it as well. I do understand the equation.

I need extra regression line for MIN (X,Y) and Max (X,Y). (Want to emphasize the bandwidth)
Adding an extra trend line is no problem either, but to position it on the proper coordinates.

Do you have a suggestion form me :confused:
(read the other messages on the board but did they didn't work for me).
 
Last edited:
A trend-line between the value of the lowest X and the lowest Y variable and the same for the max value of the X and Y.
 
Upvote 0
A workaround would be to plot a new series on the chart with those two points (minx,miny),(maxx,maxy) and then the linear trendline for that series will join them. However, if you want a proper prediction or confidence interval on the regression then that is a whole other story and probably best done in other software.
 
Upvote 0
Thanks for your sugestion I don't of this answers my question but I'll give it a try.
Copy and pasting a picture does not work on this board. And to send a copy of the data is not very informative for the solutoin of my quesntion. Is there an alternative for sending you the excel-sheet ?
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top