This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

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 .

VIDEO: It's easy to run a regression in Excel and you only need to understand a few data points to make sense of the results.

Outputting a Regression in Excel The first step in running regression analysis in Excel is to double-check that the free plugin Data Analysis ToolPak is installed.

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