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 .

Learn how to graph linear regression in Excel. Use these steps to analyze the linear relationship between an independent and a dependent variable.

How Is Beta Computed? Beta is essentially the regression coefficient of a stock's historical returns compared to those of the S&P 500 index.