offsetting a line

  • Thread starter Thread starter Dan C
  • Start date Start date
D

Dan C

Hello all!

I have made a scatter plot and added a line of best fit. Now that i
have the y=mx+b equation, I need to offset that line + 0.002 on the
y-axis. Does anyone know how to do this?

Thanks for the help!
 
Dan C,

If you want a parallel line to your y=mx+b, it becomes y=mx+b+0.002

Regards,
kevin
 
Dan,

If you don't want to change the value of b you're using, you can add it in
after the fact. Make a column that links to your original column:

=A2+.002
=A2+E1 where E1 is the offset cell.

Copy down.
 
I understand that, but I don't know how I can make a line on a graph
using the y=mx+b formula. I made the line with about 30 points and I
need to have another line on the same graph that is offset by .002. So
the formula would go from

y=67008x+0.6195
to
y=67008x+0.6215

Can I make another line using the y=mx+b formula, or do I have to
create new points? If I have to create new points, what would I have
to change them to?

Thanks again
 
Back
Top