TREND
Returns values along a linear trend.
StatisticalStatistics & Analysis
What it does
Calculates linear trend values (like FORECAST but for arrays).
Syntax
TREND(known_y's, [known_x's], [new_x's], [const])
Arguments
known_y's(range) — Y values.known_x's(range) — X values.
Examples
Trend Array
Forecast next 2 points.
FORMULA
=TREND(B2:B4, A2:A4, A5:A6)
RESULT
[400; 500]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | X | Y |
| 2 | 1 | 100 |
| 3 | 2 | 200 |
| 4 | 3 | 300 |
| 5 | 4 | |
| 6 | 5 |