How To Find Trend Value By Least Square Method. Answered aug 26, 2020 by vijay01 (50.3k points) selected aug 26, 2020 by abhijeetkumar. The method can be used when the trend is linear, exponential, or quadratic.

Therefore, the required equation of the straight line trend is given by. To use the method of least squares to fit a regression line in excel, we can use the =linest() function. Therefore, the equation of yc = 20 + 3.5x.