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.

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.