A function that predicts future values based on existing historical data using linear regression.
Wypróbuj z SIThe FORECAST function calculates or predicts a future value by using existing values. It fits a linear trend line through historical data points to estimate a new data point for a specified future period.
FORECAST(x, known_y's, known_x's)If you have sales data for January through June, you can use FORECAST to estimate the sales figure for July.
No, it is specifically designed for linear trends; for non-linear data, consider using FORECAST.ETS.