Right-click on any data point in the chart and select “Add Trendline” to include a regression line. The regression line provides a visual representation of the relationship between your variables.

Microsoft Excel 2010 has the ability to smooth the line between data points on a graph to create a curved graph. However, you do not see this option when you create a graph using the standard ...

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 .