This article explains how to do regression in Excel, which is a way to automate the statistical process of comparing several sets of information to see how changes in independent variables affect ...

Excel 2013 can compare this data to determine the correlation which is defined by a regression equation. This equation calculates the expected value of the second variable based on the actual ...

Experimental data in x/y form and data calculated from a regression equation are inputted and plotted in a Microsoft Excel worksheet, and the sum of squared residuals is computed and minimized ...

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 .