Excel can make calculating correlation a breeze but be sure you understand the results before you take action. Check with an advisor to make sure you’re on the right page before you part with ...

You can use several methods to calculate correlation in Excel. Understanding Correlation. The correlation coefficient ranges from -1 to 1. Exactly 1 is considered perfect.