Before we learn how to perform multivariate regression in Excel, it is important to have a refresher on regression as a whole and multivariate regression in particular.

Learn how to perform regression analysis of your data in Microsoft Excel, a statistical process that helps you understand the relationship ...

Experimental data in x/y form and data calculated from a regression equation are inputted and plotted in a Microsoft Excel worksheet, and the sum of squared residuals is computed and minimized ...

VIDEO: It's easy to run a regression in Excel and you only need to understand a few data points to make sense of the results.

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.