How To Find The Slope Of The Least Squares Regression Line In Excel. First, let’s create the following dataset in excel: The formula for the line of the best fit with least squares estimation is then:

What is the least squares regression method and why use it? The last two arguments can be set to true or omitted. For paired data ( x,y ) we denote the standard deviation of the x data by s x.