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.

The residual sum of squares (RSS) is a statistical technique used to measure the variance in a data set that is not explained by the regression model.