Google スプレッドシート関数

GROWTH

Calculates predicted exponential growth by using existing data.

この関数は 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.

GROWTH

構文

引数

例

よくある質問

関連する関数

GROWTH

構文

引数

例

よくある質問

関連する関数