View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default How to determine the correlation between two lists of numbers?

Sun, 11 Nov 2007 18:56:01 -0800 from Eric
:

"Stan Brown" wrote:

Sun, 11 Nov 2007 17:54:04 -0800 from Eric
:
Does anyone have any suggestions on how to determine the strength on
correlation between two lists of numbers?


Insert | Function
and type Correlation in the search box.


Thank you very much for your suggestions
If two lists of numbers are different in scale, do you have any suggestions
on how to fix it before performing correlation?
For example,
List 1 : 3,5,4,7,8,2,5,6,7,8
List 1 : 44,66,54,78,34,87,95,34,67,87


There's nothing to "fix". The data are what they are.

Maybe you said "correlation" but actually meant something else?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/