Linear Line

[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

 

[dvt]

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

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