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 .

VIDEO: It's easy to run a regression in Excel and you only need to understand a few data points to make sense of the results.

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.