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

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.

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

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 .

First, multiple linear regression models are considered and the design matrices are allowed to be different. Second, the predictor variables are either unconstrained or constrained to finite intervals ...