FORECAST
Returns a value along a linear trend This function has been replaced with FORECAST.LINEAR as part of the new Forecasting, but it's still available for compatibility with earlier versions.
StatisticalStatistics & Analysis
What it does
Calculates a future value along a linear trend (Legacy).
Syntax
FORECAST(x, known_y's, known_x's)
Arguments
x(number) — Data point.known_y's(range) — Dependent range.known_x's(range) — Independent range.
Examples
Linear Forecast
Forecast y for x=30.
FORMULA
=FORECAST(30, B2:B4, A2:A4)
RESULT
300
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | X | Y |
| 2 | 10 | 100 |
| 3 | 20 | 200 |
| 4 | 40 | 400 |