Enable the Analysis ToolPak add-in to discover interesting correlations in your data This article explains how to do regression in Excel, which is a way to automate the statistical process of ...

Select “Data Analysis” from the Analysis group. If you don’t see it, you may need to add the Analysis ToolPak add-in. Choose “Regression” from the list of analysis tools and click “OK”.

Learn how to graph linear regression in Excel. Use these steps to analyze the linear relationship between an independent and a dependent variable.

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.