Función de Google Sheets

GROWTH

Calculates predicted exponential growth by using existing data.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

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_ysobligatorioThe 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.

Ejemplos

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

Resultado: 80

Predicts the next value in the doubling sequence.

Preguntas frecuentes

What is the difference between GROWTH and TREND?

GROWTH calculates exponential trends, while TREND calculates linear trends.

Funciones relacionadas

TREND FORECAST LINEST