Learn how to graph linear regression in Excel. Use these steps to analyze the linear relationship between an independent and a dependent variable.

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.

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 .

Simple linear regression is commonly used in forecasting and financial analysis—for a company to tell how a change in the GDP could affect sales, for example. Microsoft Excel and other software ...

The first step in running regression analysis in Excel is to double-check that the free plugin Data Analysis ToolPak is installed. This plugin makes calculating a range of statistics very easy.