How to Do a Regression on Excel?

Enable the Analysis ToolPak

Go to File

Click Options

Click Add-ins

In Manage, select Excel Add-ins

Click Go

Check Analysis ToolPak

Click OK

Arrange your data in columns

Put the dependent variable in one column

Put the independent variable(s) in separate column(s)

Click the Data tab

Click Data Analysis

Select Regression

Click OK

Set the Input Y Range

Set the Input X Range

Check Labels if your ranges include headers

Choose an Output Range or New Worksheet Ply

Select any desired options

Click OK

Review the regression output

Check R Square

Check coefficients

Check p-values

Check standard error

Check residual output if needed

Suggested for You

Trending Today