Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interpreting Correlation result
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interpreting Values | Charts and Charting in Excel | |||
Excel is interpreting my TEXT... I wish it would not! | Excel Discussion (Misc queries) | |||
Interpreting some code in C | Excel Programming | |||
help interpreting expression | Excel Worksheet Functions | |||
Excel interpreting HTML and CR/LF | Excel Programming |