Função do Google Sheets

GROWTH

Calculates predicted exponential growth by using existing data.

Gerar uma fórmula com IA A mesma função no Excel

Esta função funciona no Google Sheets da mesma forma que no Excel — mesma sintaxe e argumentos.

Sintaxe

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.

Argumentos

known_ysobrigatórioThe set of y-values you already know in the relationship y = b * m^x.
known_xsopcionalAn optional set of x-values you may already know in the relationship.
new_xsopcionalNew x-values for which you want to return corresponding y-values.
constopcionalA logical value specifying whether to force the constant b to equal 1.

Exemplos

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

Resultado: 80

Predicts the next value in the doubling sequence.

Perguntas frequentes

What is the difference between GROWTH and TREND?

GROWTH calculates exponential trends, while TREND calculates linear trends.

Funções relacionadas

TREND FORECAST LINEST