LINEST function


Name in English:LINEST

That makes?

Calculates statistics for a line using the “least squares” method to find the straight line that best fits the data, and returns a matrix that describes the line.


LINEST ( known_y , [known_x], [constant], [statistic])

  • known_y (required ): The y values ​​that are known in the equation y = mx + b.
  • known_x (optional ): The x values ​​that can be found in the equation y = mx + b.
  • constant (optional ): Logical value that indicates whether the constant b will be set to zero.
  • statistics (optional ): Indicates whether additional regression statistics will be returned.


LINEST ({1,9,5,7}, {0,4,2,3}) = 2

Leave a Comment