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 .

Microsoft Excel can generate trend lines based on data you provide, and in doing do, calculates the equation of the trend line. This equation can be accessed using Excel's built-in Visual Basic tools.

Course TopicsIn this short course we will cover how to analyze simple and multiple linear regression models. You will learn concepts in linear regression such as:1) How to use the F-test to determine ...