LINEST function

LINEST(knownYValues, knownXValues?) LINEST(knownYValues; knownXValues?)

knownYValues — { Number }

The set of known vertical values. This array must have the same size as the knownXValues parameter, if that parameter is provided.

knownXValues — { Number } (optional)

The set of known horizontal values. If provided, this array must have the same size as the knownYValues parameter. If omitted, this parameter is assumed to be equivalent to SEQUENCE(SIZE(knownYValues))SEQUENCE(SIZE(knownYValues)): { 1, 2, 3, ... }{ 1; 2; 3; ... }.

Returns — { Number }

An array containing two values corresponding to m and b in the equation y = x * x + b, describing a straight line that best fits the given data.

Finds a straight line, y = m * x + b, that best fits the given data, and returns an array containing two values corresponding to m and b in the equation above. This function uses linear regression.

Example

LINEST({ 4, 5, 6 }, { 130, 135, 140 })LINEST({ 4; 5; 6 }; { 130; 135; 140 })

Returns the array { 0.2, -22 }{ 0,2; -22 }.