Linear Line

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have 8 x,y coordinates. Is there a function (I've played with SLOPE
without results) that can check if the line formed is linear through
all points.

Thanks in advance
 
Mike said:
I have 8 x,y coordinates. Is there a function (I've played with SLOPE
without results) that can check if the line formed is linear through
all points.

Thanks in advance
Click to expand...

Did you see Dana DeLouis' suggestion? I've pasted it below:

If the data is on a worksheet, I believe the following should work.

=RSQ(Y_Range,X_Range)

A value of 1 should indicate a straight line.

Dave
dvt at psu dot edu
 
Back
Top