Home › Functions › Compare LOGEST vs GROWTH

Compare LOGEST vs GROWTH

2 vs

Compare LOGEST vs GROWTH side-by-side — differences, popularity and recommendation

Presets: VLOOKUP vs XLOOKUP SUM vs SUMIFS INDEX vs MATCH vs XLOOKUP IF vs IFS vs SWITCH COUNT vs COUNTA vs COUNTIF AVERAGE vs AVERAGEIF vs AVERAGEIFS MAX vs LARGE vs MIN TEXT vs TEXTJOIN vs CONCAT FILTER vs SORT vs UNIQUE ROUND vs ROUNDUP vs ROUNDDOWN
All functions Pick at least 2 functions
Feature
Statistical
=LOGEST()
Syntax
Statistical
=GROWTH()
★ Winner
Syntax
Category
Statistical statistical
Statistical statistical
Popularity
6 / 100
15 / 100
Views
◉ 20 views
◉ 20 views
Output
Array
Array
Version
All versions
All versions
Volatile
No
No
Dynamic Array
No
No
Description
The equation for the curve is: y = b*m^x or y = (b*(m1^x1)*(m2^x2)*_) if there are multiple x-values, where the dependent y-value is a function of the independent x-values. The m-values are bases corresponding to each exponent x-value, and b is a constant value. Note that y, x, and m can be vectors. The array that LOGEST returns is {mn,mn-1,...,m1,b}.
Calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an exponential curve to existing x-values and y-values.
Syntax
=LOGEST(known_y's, [known_x's], [const], [stats])
=GROWTH(known_y's, [known_x's], [new_x's], [const])
Arguments
4 Arguments
known_y's known_x's (Optional) const (Optional) stats (Optional)
4 Arguments
known_y's known_x's (Optional) new_x's (Optional) const (Optional)
Examples
2
2
Tips
4
2

★ Recommendation — Winner: =GROWTH()

=GROWTH() is recommended based on higher popularity, newer version and Dynamic Array support.

Winner: =GROWTH()