=LINEST(B2:B12, A2:A12, TRUE, TRUE) This function will calculate the slope of the regression line, the y-intercept, and several other statistics.

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 ...

We couldn’t find any results matching your search. ... How to Calculate the Regression of 2 Stocks Using Excel April 06, 2016 — 11:21 am EDT.