How to Make a Regression Table in Excel. ... Click the radio button next to "Output Range"; then place your cursor into the text box next to the radio button and click on cell C1.

It's easy to run a regression in Excel. The output contains a ton of information but you only need to understand a few key data points to make sense of your regression. You need the Analysis ...

Regression statistics will typically include an R-squared value. The closer to 1 this is, the stronger the correlation between the returns of the two stocks. An R-squared figure of zero indicates ...

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 .