Syntax. LINEST(known_y’s,known_x’s,const,stats)

Definition. This function calculates the statistics for a line using the smallest squares to calculate a straight line appropriate for the data and then returns an array describing a line. Because this function returns an array of values, it must be entered as an array formula.

The equation for the line is:

y = mx + b

or, if there are multiple ranges of x-values:

y = m1x1 + m2x2 + ... + b

The dependent y-values are a function of the independent x-values. The m-values are coefficients corresponding to each x-value, and b is a constant value. Note that y, x, and m can be vectors. The array that the LINEST() function returns is {mn,mn-1,...,m1,b}. LINEST() can also return additional regression statistics ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.