FORECAST
Category: Statistical Function.
Description: Calculates a future value by using existing values.
The predicted value is a y-value for given x-value.
The known values are existing x-values and y-values, and the new value is predicted by using linear regression.
Syntax: FORECAST(x, known_y's, known_x's)
The FORECAST function syntax has the following arguments:
X: data point for which you want to predict a value.
Known_y's: dependent array or range of data.
Known_x's: dependent array or range of data.