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