You can do this by going to File > Options > Add-Ins and selecting Excel Add-ins, then checking the box for the Data Analysis Toolpak. Access the regression tool by navigating to Data > Data ...

How to Do Regression Analysis Accounting. Regression analysis is a method of determining the relationship between two sets of variables when one set is dependent on the other.

Quantitative analysis (QA) seeks to understand behavior by using mathematical and statistical modeling, measurement, and research.

Under the Data menu, the Data Analysis button allows you to select Regression. If you don't have a Data Analysis option available, then you'll need to download the Analysis ToolPak from Excel.

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