Check the boxes that say “Residuals” and “Residual Plots ” this will be important later on in our analysis and conclusions.

If you want your regression output to be inserted onto a new worksheet page, check the box for “New Worksheet Ply”.

Select the “Labels” box so that your output sheet will include the corresponding data labels.

Input X Range → select the data for the variable you are using to predict the other variable independent variable.

Input Y Range → select the data for the variable you are trying to predict dependent variable.

Select “Data” tab → Select “Data Analysis” → Select “Regression”.

Here is a brief outline of how to conduct your regression analysis using Excel: Once it is activated, you are good to go!

It is fairly simple, so this shouldn’t take any longer than a minute or two. How to activate the ToolPak will depend on what version of Excel you are running, so I would recommend just doing a quick Google search on how to set it up. In order to conduct a regression analysis in Excel, you need to make sure that your Analysis ToolPak is activated. Testing single linear regression can be done by hand, but it is much easier and quicker to use tools like Excel or Jupyter Notebook to create predictive models.

When we scatter our data, we find that the relationship between the living room size and the price is approximately linear, meaning we now have the thumbs up to begin our linear regression. On the left we have all of our data points scattered, and on the right we have the same graph except the line of best fit that we are trying to find is included as well: Before we jump into calculations, we first want to make sure that we can actually use the linear regression methodology this means we need to check to see if the relationship between our living room size and price is approximately linear. Now that we know that there is something going on between those variables, we want to see if the living room size can be used to predict the price of our house. When we calculated correlation, we found a pretty strong correlation between the size of the living room and the price. Some of these concepts are difficult to understand on their own, so let’s apply them to our example housing data set to see them in action. It is the same equation as your standard y= mx + b that you learned back in Algebra I, just written a little differently in statistics language. This equation may look familiar, and it should. x → the independent variable aka the variable we are using to predict y.

Predictive analytics excel