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.

Next, have Excel run the regression on the two columns of return data you generated. Under the Data menu, the Data Analysis button allows you to select Regression. If you don't have a Data ...