LINEST function
KnownYValues
The set of known vertical values. This array must have the same size as
the knownXValues parameter, if that parameter is provided.
KnownXValues
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
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.