Google Sheets-functie

GROWTH

Calculates predicted exponential growth by using existing data.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

GROWTH(known_ys, [known_xs], [new_xs], [const])

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.

Argumenten

known_ysvereistThe set of y-values you already know in the relationship y = b * m^x.
known_xsoptioneelAn optional set of x-values you may already know in the relationship.
new_xsoptioneelNew x-values for which you want to return corresponding y-values.
constoptioneelA logical value specifying whether to force the constant b to equal 1.

Voorbeelden

=GROWTH({10,20,40}, {1,2,3}, {4})

Resultaat: 80

Predicts the next value in the doubling sequence.

Veelgestelde vragen

What is the difference between GROWTH and TREND?

GROWTH calculates exponential trends, while TREND calculates linear trends.

Gerelateerde functies

TREND FORECAST LINEST