This function calculates future value by using existing values.
FORECAST.LINEAR(x, known_y, known_x)
This function has the following arguments:
| Argument | Description |
|---|---|
| x | Refers to the numeric data specyfing data point to predict a value for. |
| known_y | Refers to the numeric data (array) specifying known y-values. |
| known_x | Refers to the numeric data (array) specifying known x-values. |
This function predicts a new value on a linear basis. Hence, if the data follows seasonal variances, this function is not useful.
Accepts only numeric data. Returns numeric data.
FORECAST.LINEAR( 7, B4:B8, C4:C8 )
This function is available in product version 11.0 or later.