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 .

Excel 2013 can compare this data to determine the correlation which is defined by a regression equation. This equation calculates the expected value of the second variable based on the actual ...

To calculate the sum of squares using Microsoft Excel, you need to input a specific formula into the formula bar of the cell you're working with.