FORECAST
Predicts a future value along a linear trend using existing x and y values.
| Category | Statistical |
| Syntax | FORECAST(x, known_ys, known_xs) |
Parameters
| Parameter | Required | Description |
|---|---|---|
x | Required | The x value for which you want to predict a y value. |
known_ys | Required | The range or array of known dependent (y) values. |
known_xs | Required | The range or array of known independent (x) values. |
Example
FORECAST(A1:A10)
Auto-generated from the EngCanvas function registry.