Linear Line

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
 
D

dvt

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
 
Top