Regression Analysis In Excel

Regression Analysis In Excel

In other words Regression is a method of estimating the portion of a cost that is variable and the portion that is fixed. The following tutorial will help you use Excel to “run” a regression.

Accessing Regression Analysis in Microsoft Excel

Go to File > Excel Options > Add-Ins > click Analysis ToolPak > then click GO

Following dialog box will be open, Click Analysis Toolpak and then click OK.

Data Analysis button will appear on Data ribbon. Under Data Analysis feature Regression function can be found.

Once Data Analysis is enabled, open it and choose the Regression and click ok button.

• Input Y Range option: Select dependent variables
• Input X Range option: Select independent variables.
• Output options specify how you would like the results to be displayed,
• Residuals contain options to draw the results as charts.

For practice type X & Y values in the following style:

Once you click the Ok button following regression table will be created in new sheet as follows.

Template

Further reading: 
How to use Analysis ToolPak Add-in?
Camera Tool
How Excel handles different data types?
Linear Regression
Multiple Regression
Basic concepts 
Getting started with Excel
Cell References