How to determine the correlation between two lists of numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
Click to expand...

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

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

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

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