Funzione di Google Sheets

GROWTH

Calculates predicted exponential growth by using existing data.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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.

Argomenti

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

Esempi

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

Risultato: 80

Predicts the next value in the doubling sequence.

Domande frequenti

What is the difference between GROWTH and TREND?

GROWTH calculates exponential trends, while TREND calculates linear trends.

Funzioni correlate

TREND FORECAST LINEST