Functions
FORECAST.LINEAR
Forecast using linear regression
Try it
When to use it
When should I use FORECAST.LINEAR instead of FORECAST?
FORECAST.LINEAR is the modern replacement for FORECAST; they are functionally identical but FORECAST.LINEAR is preferred in new spreadsheets for consistency with the .LINEAR naming convention.
Used in
Syntax
FORECAST.LINEAR(x,known_y,known_x)Examples
=FORECAST.LINEAR(5,{2,4,6,8},{1,2,3,4}) // => 10
=FORECAST.LINEAR(1,{2,4,6,8},{1,2,3,4}) // => 2
=FORECAST.LINEAR(10,{2,4,6,8},{1,2,3,4}) // => 20