Enable the Analysis ToolPak add-in to discover interesting correlations in your data This article explains how to do regression in Excel, which is a way to automate the statistical process 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 .

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