To perform power regression in Excel, you can use the LINEST function or the Regression tool in the Data Analysis add-in, after transforming the data by taking the logarithm of both sides.

Note: Instructions in this article apply to Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.

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.

The first one is the either the single input or multi-variate linear regression depending on how many input features for X axis. There will be annotation about the coefficient of determination and the ...

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 .