** Syntax**. LINEST(

** 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* = *m*1*x*1 + *m*2*x*2 + ... + *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 ...

Start Free Trial

No credit card required