Next, have Excel run the regression on the two columns of return data you generated. Under the Data menu, the Data Analysis button allows you to select Regression.

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.

Find out how to perform financial analysis through Microsoft Excel, a widely used business management software among finance professionals and investors.

How to Make a Regression Table in Excel. Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a ...

It's easy to run a regression in Excel. The output contains a ton of information but you only need to understand a few key data points to make sense of your regression. You need the Analysis ...

Understanding one of the most important types of data analysis. by Amy Gallo You probably know by now that whenever possible you should be making data-driven decisions at work. But do you know how ...

The Data Analysis for Excel Video Series is designed to supplement Lesson 3 in the AQ-IQ curriculum. Learn about units of Air Quality PollutantsAQ-IQ Mentor Elise Mesenbring explains the concentration ...