Pick one column to be the Y range and the other to be the X range. What the results ... The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com.