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.

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.

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.

Want to get an idea of how to deal with a large amount of data? Trying to discern a pattern in your dataset? You're going to want to use LINEST, the Excel feature that runs a simple linear ...