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.

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.

THE “simplified” method of calculating a linear regression put forward by Aldridge, Berry and Davies 1 is the well-known method of orthogonal polynomials which was put on a practical working ...

If the relationship between these variables is linear, then it is possible, by spacing the intervals equally with reference to the independent variable, to calculate the slope of the line, using ...