How to determine the correlation between two lists of numbers?
 

Does anyone have any suggestions on how to determine the strength on
correlation between two lists of numbers?

Thanks in advance for any suggestions
Eric

How to determine the correlation between two lists of numbers?
 

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.

--
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/

How to determine the correlation between two lists of numbers?
 

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

Do you have any suggestions?
Thanks in advance for any suggestions
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.

--
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/

How to determine the correlation between two lists of numbers?
 

Eric -

You do not need to change the scale of the data.

You can use the CORREL or PEARSON worksheet functions to obtain the
correlation coefficient (-1<=R<=+1).

See Excel's built-in Help for information.

The correlation coefficient measures the extent of linear relationship, so
first you should plot the data using an XY (Scatter) chart type to verify
that the relationship is linear. If the relationship is not linear, the
correlation coefficient is not an appropriate measure.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"Eric" wrote in message
...
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

Do you have any suggestions?
Thanks in advance for any suggestions
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.

--
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/

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/