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, subtract the mean from the data points, square the differences, and add them together. There are three types of sum of squares: total, residual, and regression.