Functions
LINEST
Returns linear regression statistics
Try it
When to use it
When should I use LINEST?
Use LINEST to obtain linear regression statistics (slope, intercept, and optional extended statistics) for a set of known x and y values.
Used in
Syntax
LINEST(known_y, [known_x], [const], [stats])Examples
=LINEST({1,2,3,4},{1,2,3,4}) // => 0.9999999999999998
=LINEST({2,4,6,8},{1,2,3,4},TRUE) // => 1.9999999999999996
=LINEST({2,4,6,8},{1,2,3,4},FALSE) // => 2