You need the Analysis Toolpak add-in to run regressions. It comes with Excel but you may need to load it if you don't see Data Analysis under the Data toolbar.

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 .