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 .

Open Excel. Enter the start and end years in cells B1 and C1, respectively. As an example, enter "2008" and "2011." Enter "Decline" and "Annualized Decline" in cells D1 and E1.