Category:**Statistics**

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.

## Syntax

**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.

## Examples

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