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

We can chart a regression in Excel by highlighting the data and charting it as a scatter plot. To add a regression line, choose "Add Chart Element" from the "Chart Design" menu.

Linear Regression vs. Multiple Regression Example Consider an analyst who wishes to establish a relationship between the daily change in a company's stock prices and daily changes in trading volume.

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