LINEST
Returns the parameters of a linear trend
Syntax
LINEST(known_y's, [known_x's], [const], [stats])
Parameters
- known_y's: Required. The set of y-values
- known_x's: Optional. The set of x-values
- const: Optional. TRUE to calculate b normally (default), FALSE to set b = 0
- stats: Optional. TRUE to return additional regression statistics; FALSE (default) to return only m and b coefficients
Example
=LINEST(A1:A10, B1:B10, TRUE, TRUE)