FORECAST function
The FORECAST function is one of the statistical functions. It is used to predict a future value based on existing values provided.
Syntax
FORECAST(x, known_y's, known_x's)
The FORECAST function has the following arguments:
| Argument | Description |
|---|---|
| x | An x-value used to predict the y-value. |
| known_y's | The dependent data range. |
| known_x's | The independent data range with the same number of elements as known_y's contains. |
Notes
How to apply the FORECAST function.
Examples
The figure below displays the result returned by the FORECAST function.
