Functions
FORECAST
Forecast using linear regression
Try it
When to use it
When should I use FORECAST?
Use FORECAST to predict a future value along a linear trend given a set of known x and y values, such as estimating next month's sales from historical data.
Used in
Syntax
FORECAST(x,known_y,known_x)Examples
=FORECAST(5,{2,4,6,8,10},{1,2,3,4,5}) // => 10
=FORECAST(10,{3,5,7,9},{1,2,3,4}) // => 21