The correlation coefficient is the ratio of the covariance over the standard deviations.
In this case it would be smart to subtract off a number like 2000 or 1990 from the first column.
If the first column are x's and the second are y's, you will need...

Thank you for your help but now i am more confussed is there any way you could please break it down for me

Thank you

Originally Posted by matheagle

The correlation coefficient is the ratio of the covariance over the standard deviations.
In this case it would be smart to subtract off a number like 2000 or 1990 from the first column.
If the first column are x's and the second are y's, you will need...