Calculates predicted exponential growth by using existing data.
الصيغة
GROWTH(known_ys, [known_xs], [new_xs], [const])المعاملات
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.
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.
=GROWTH({10,20,40}, {1,2,3}, {4})→80Predicts the next value in the doubling sequence.
Prepare your data
Ensure your known y-values and x-values are in adjacent rows or columns.
Enter the formula
Select a cell and input the GROWTH function with your known data ranges.
GROWTH calculates exponential trends, while TREND calculates linear trends.