How to determine the correlation between two lists of numbers?

[Guest]

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

 

[Stan Brown]

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.

 

[Guest]

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

 

[Mike Middleton]

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

 

[Stan Brown]

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

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?