

Press OK to display the Regression dialog box. Select (Data > Data Analysis) and choose Regression in the Data Analysis dialog box. Lets assume we have the following table of data. The line is called the "least square fit" and the process of finding this line is called "least square fit regression" "the line where the sum of squares of the differences to all data points has the smallest possible value" The best fit line can be defined mathematically as: This is known as the method of least squares.Īll linear regressions take the equation y = mx + b
:max_bytes(150000):strip_icc()/006-how-to-run-regression-in-excel-4690640-d95adcb0c21f414db3d162701e04575f.jpg)
It can be shown mathematically that the best line is one that minimises the total of the squared deviations. You can analyze how a single dependent variable is affected by the values of one or more independent variables. Regression attempts to show the relationship between two variables by providing a mean line which best indicates the trend of the co-ordinates.

The Regression analysis tool performs linear regression analysis by using the "least squares" method to fit a line through a set of observations.
