Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to get multiple regression lines on 1 graph?

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •