Функция Google Таблиц

GROWTH

Calculates predicted exponential growth by using existing data.

Создать формулу с ИИ Та же функция в Excel

Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.

Синтаксис

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.

Аргументы

known_ysобязательноThe set of y-values you already know in the relationship y = b * m^x.
known_xsнеобязательноAn optional set of x-values you may already know in the relationship.
new_xsнеобязательноNew x-values for which you want to return corresponding y-values.
constнеобязательноA logical value specifying whether to force the constant b to equal 1.

Примеры

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

Результат: 80

Predicts the next value in the doubling sequence.

Вопросы и ответы

What is the difference between GROWTH and TREND?

GROWTH calculates exponential trends, while TREND calculates linear trends.

Связанные функции

TREND FORECAST LINEST