Linear Line

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

Mike

Firstly, apologies as this will appear twice. I sent it via Google and they
said it'll be 3-8 hours before posted, now if I had 3-8 hours that'd be
useful!

My question: I have 8 sets of x,y coordinates, is there a function that can
tell me if all points are linear (i.e. form a straight line).

Thanks in advance
Mike
 
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.

Note: It returns the same value as if you selected 3 vertical cells and
Array entered the following...
=LINEST(Y,X,,TRUE)

The R^2 value is the third value listed.

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


Hi Mike,
There was a long thread in the VB group on this earlier this month.
Some heavy programming but you may find what your looking for.

http://www.google.com/groups?hl=en&...=UTF-8&as_ugroup=*vb*&lr=lang_en&num=50&hl=en
 
=CORREL(y_range,x_range)^2

is a more numerically stable way to calculate this quantity.

Jerry
 
Back
Top