Correlation
Calculates the correlation of two sets of numeric data.
The correlation coefficient (a value between -1 and +1) means how strongly two variables are related to each other. You can use the CORREL function or the Data Statistics to find the correlation coefficient between two variables.
A correlation coefficient of +1 indicates a perfect positive correlation.
A correlation coefficient of -1 indicates a perfect negative correlation
For more information on statistical correlation, refer to the corresponding Wikipedia article.
The following table displays the results of the correlation of the sample data above.
|
Correlations |
Column 1 |
Column 2 |
Column 3 |
|
Column 1 |
1 |
||
|
Column 2 |
-0.4029254917 |
1 |
|
|
Column 3 |
-0.2107642836 |
0.2309714048 |
1 |