Google スプレッドシート関数

TREND

Returns values along a linear trend.

この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。

構文

TREND(known_ys, [known_xs], [new_xs], [const])

The TREND function calculates a linear trend line through a given set of data points using the least squares method. It returns the y-values along that line for the specified new x-values.

引数

known_ys必須The set of y-values you already know in the relationship y = mx + b.
known_xs省略可能The optional set of x-values you already know.
new_xs省略可能The 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 0.

例

=TREND({10,20,30}, {1,2,3}, {4})

結果: 40

Predicts the y-value for x=4 based on the linear trend of the provided data.

よくある質問

What happens if known_xs is omitted?

If omitted, it is assumed to be the array {1, 2, 3, ...} of the same size as known_ys.

TREND

構文

引数

例

よくある質問

関連する関数

TREND

構文

引数

例

よくある質問

関連する関数