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.

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.

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.

Outputting a Regression in Excel The first step in running regression analysis in Excel is to double-check that the free plugin Data Analysis ToolPak is installed.

How to Calculate T-Value From Mean & Standard Deviation in Excel. Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas. T-values, also known ...

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

How to Calculate Multiple Cells in Excel. Microsoft Excel is a spreadsheet program used to store and analyze data. While Excel is able to hold both text and numerical data, most of the pre ...