Add a linear regression line to the scatter chart by clicking the "Layout" tab, selecting the "Trendline" drop-down box and clicking "Trendline Options." Select the "Linear" option and click the ...

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

How to Make a Regression Table in Excel. Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a ...

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.

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 .

Learn the difference between linear regression and multiple regression and how investors can use these types of statistical analysis.