How to get multiple regression lines on 1 graph?

BRADX · May 10th, 2002, 07:10 AM

I was wondering if anyone knows how to get multiple regression lines on 1 graph. Specifically, I would like to take some points and plot the first regression line of the entire data, than I just want to add a second regression line of just the positive X data, and finally a third line of a regression of the negative values. If anyone knows how I can get excel to plot more than one line like this it would be greatly appreciated.
Thanks a lot

Corni · Jun 2nd, 2002, 09:18 PM

The only solution I used when I needed to segement the data set was to add additional data series, for ex. the positive or negative values in your case, and then add the regression line associated to that new series.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 07:10 AM	#1
BRADX New Member Join Date: May 2002 Posts: 8	I was wondering if anyone knows how to get multiple regression lines on 1 graph. Specifically, I would like to take some points and plot the first regression line of the entire data, than I just want to add a second regression line of just the positive X data, and finally a third line of a regression of the negative values. If anyone knows how I can get excel to plot more than one line like this it would be greatly appreciated. Thanks a lot

Jun 2nd, 2002, 09:18 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	The only solution I used when I needed to segement the data set was to add additional data series, for ex. the positive or negative values in your case, and then add the regression line associated to that new series.