The most mathematically sound method is to find the covariance for the two variables and the standard deviations of each variable, then use the following formula: Correlation Coefficient=COVSDMI ...

The correlation coefficient always returns a value ... then use the following formula: Finding the covariance and standard deviation for each variable can be a lengthy, involved process.