You can use linear regression to compare two or more variables, such as a specific stock with a benchmark, to determine their dependence, which can help make certain investment decisions.

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 .

Using a data set chart, we can observe what the linear relationship of the various data points, or numbers, is. We do this by drawing a regression line, which attempts to minimize the distance of ...

The next time you cover this topic, consider teaching students how to perform a simple linear regression analysis in Excel. Below is an example screenshot illustrating 12 months of cost data for a ...

Using Excel, pick a cell and enter the formula: "SLOPE" which represents the linear regression applied between the two variables; the first for the series of daily returns of Apple (here: 750 ...