Interpreting Correlation result

E

Elijah

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.
 
M

Mike Middleton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
VBA to run all variable combinations in a calculation model and store result 6
comparing data 0
Automating Calculation of Lagged Cross Correlations between Variables 1
How to create a correlation matrix in excel? 6
How to determine the optimized correlation between 2 sets of data? 1
How to Use VBA to Group and Transpose Data... 0
counting elements of two arrays 6

Top