View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default Interpreting Correlation result

Elijah -

The values "1" on the diagonal indicate that each variable is perfectly
correlated with itself.

The value "6.77675E-15," i.e., 6.77675*(10^(-15)), indicates that the
correlation between Column 1 and Column 2 is essentially zero.

This is the same result you get with the CORREL worksheet function.

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



"Elijah" wrote in message
...
I need information on how I can interprete the result gotten from
correlation.

Basically what I am doing is to compare two data sets in two column.

I got the following result when I used correlation data analysis tool in
excel:

Column 1 Column 2
Column 1 1
Column 2 6.77675E-15 1


Any feedbacks would hopefully be helpful.
Regards,
Elijah.