Calculates predicted exponential growth by using existing data.
Syntaxis
GROWTH(known_ys, [known_xs], [new_xs], [const])Argumenten
known_ysvereist
The set of y-values you already know in the relationship y = b * m^x.
known_xsoptioneel
An optional set of x-values you may already know in the relationship.
new_xsoptioneel
New x-values for which you want to return corresponding y-values.
constoptioneel
A logical value specifying whether to force the constant b to equal 1.
The GROWTH function returns values along an exponential trend. It uses the least squares method to fit an exponential curve to your existing data points.
=GROWTH({10,20,40}, {1,2,3}, {4})→80Predicts the next value in the doubling sequence.
Prepare your data
Ensure your known y-values and x-values are in adjacent rows or columns.
Enter the formula
Select a cell and input the GROWTH function with your known data ranges.
GROWTH calculates exponential trends, while TREND calculates linear trends.