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.

Finding Correlation on a Graphing Calculator . A graphing calculator, such as a TI-84, can also be used to calculate the correlation coefficient. The following instructions are provided by Statology.

The article How to Calculate Beta From Volatility and Correlation originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

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.