We can perform simple linear regression in excel. interval or ratio, and one independent variable i.e. In simple linear regression, there is one dependent variable i.e. If it is greater than 0.05, you will have to replace the value in order to get the accuracy. If the value is less than 0.05, the model is OK. In this part, “Significance F” value shows the accuracy of the model.

Now, we take a look at the second part of the output “ANOVA”.

Observation: Shows the number of observations.

Standard Error: It shows the precision of the regression analysis performed by us.

Adjusted R Square: It is adjusted for the independent variables.

R Square: It shows the points falling on the regression line.

Larger value shows a strong relationship while ‘0’ means no relationship.

Multiple R: These are the Correlation Coefficient used to measure the relationship strength of variables.

See the summary output, we have got some results but what they mean.

Press “OK” and see the regression analysis on a new worksheet.Īfter performing the regression, you will see this output.

“Residuals” selection of this checkbox will tell you the difference between actual and predicted values.

You can select the output range to put the result on specific cells or select “New Worksheet Ply” to place the result in a new worksheet.Check “Labels”, if headings are available in your table.The selection of this option will cause the regression line to start from zero. Here we have selected A1: A21 and B1: B21. Set the input value of X and Y by selecting relevant columns of values in the worksheet.On selecting “Regression” option from figure-1, you will see this. Choose “Regression” from the list of analysis tools and press “OK. A box showing the list of available tools will be opened. Now you will see “Data Analysis” option in your Data tab has appeared as shown in the below figure.Ĭlick on “Data Analysis” tool. Select “Analysis ToolPak” add-in and press OK. After pressing OK, you will see this box.

Regression data analysis tool in excel