Google Sheets 함수

GROWTH

Calculates predicted exponential growth by using existing data.

이 함수는 Google Sheets에서도 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

구문

인수

예시

자주 묻는 질문

관련 함수