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 .

Linear regression is a measurement that helps determine the strength of the relationship between a dependent variable and one or more other factors, ... How to Calculate the Residual Sum of Squares ...

Microsoft Excel serves as a tool to organize data and calculate beta. What Is Beta? An index of 1.0 is commonly selected as the benchmark for a market index like the S&P 500 index.