이 함수는 Google Sheets에서도 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.
=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.
If omitted, it is assumed to be the array {1, 2, 3, ...} of the same size as known_ys.