The slope is a value that indicates the rate at which the y value of a line rises or falls as the x value increases. Using the SLOPE function in Excel, you can find this value for a set of ...

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 .

To calculate variance in Excel, you will need to have your data set already entered into the software. ... the data points are the blue dots and the orange line is the regression line.