GROWTH
Returns values along an exponential trend.
StatisticalStatistics & Analysis
What it does
Predicts exponential growth by fitting an exponential curve to data.
Syntax
GROWTH(known_y's, [known_x's], [new_x's], [const])
Arguments
known_y's(range) — Dependent values.known_x's(range) — Independent values.
Examples
Exponential Forecast
Predict next value.
FORMULA
=GROWTH(B2:B4, A2:A4, 4)
RESULT
800
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Time | Val |
| 2 | 1 | 100 |
| 3 | 2 | 200 |
| 4 | 3 | 400 |