Calculating correlation can be time-consuming but software like Excel makes it much easier. You can use several methods to calculate correlation in Excel.

Calculate R-squared in Microsoft Excel by creating two data ranges to correlate. Use the correlation formula to correlate both sets of data, or x and y.

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .