ReferenceFunctionsStatistics Functions
GROWTH
GROWTH: Returns fitted values from an exponential trend model.
Summary
GROWTH fits y = b * m^x by linearizing in log space, then returns predictions for new_x.
Remarks
- All known y-values must be strictly greater than
0. known_xdefaults to1..n;new_xdefaults toknown_x.constdefaults toTRUE; set toFALSEto forceb = 1.- Returns spreadsheet errors for invalid domains, mismatched lengths, or degenerate x-variance.
Examples
Exponential growth forecast
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
[[16,32]]
Default x-values with perfect doubling pattern
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
[[3,6,12]]
Related functions
Runtime metadata
Category
Statistics
Signature
GROWTH(arg1…: Number (Range))This function accepts a repeating argument pattern (min args: 1).
Arity
min 1, max variadic
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PURENUMERIC_ONLY
Source