GROWTH

Definition

Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.

Syntax

GROWTH(known_data_y, [known_data_x], [new_data_x], [b])

• known_data_y - The array or range containing dependent (y) values that are already known, used to curve fit an ideal exponential growth curve.

• If known_data_y is a two-dimensional array or range, known_data_x must have the same dimensions or be omitted.

• If known_data_y is a one-dimensional array or range, known_data_x may represent multiple independent variables in a two-dimensional array or range. I.e. if known_data_y is a single row, each row in known_data_x is interpreted as a separated independent value, and analogously if known_data_y is a single column.

• known_data_x - [ OPTIONAL - {1,2,3,...} with same length as known_data_y by default ] - The values of the independent variable(s) corresponding with known_data_y.

• If known_data_y is a one-dimensional array or range, known_data_x may represent multiple independent variables in a two-dimensional array or range. I.e. if known_data_y is a single row, each row in known_data_x is interpreted as a separated independent value, and analogously if known_data_y is a single column.
• new_data_x - [ OPTIONAL - same as known_data_x by default ] - The data points to return the y values for on the ideal curve fit.

• The default behavior is to return the ideal curve fit values for the same x inputs as the existing data for comparison of known y values and their corresponding curve fit estimates.
• b - [ OPTIONAL - TRUE by default ] - Given a general exponential form of y = b*m^x for a curve fit, calculates b if TRUEor forces b to be 1 and only calculates the m values if FALSE.

Sample Usage

A
B
C
D
1
Month
Sales
2
1
\$25.93
3
2
\$30.00
4
3
\$30.00
5
4
\$34.01
6
5
\$30.00
7
6
\$34.01
8
7
\$25.93
9
8
\$30.00
10
9
\$30.00
11
12
13
14
Month
Predicted Sales
Formula Used
15
GROWTH
10
\$30.60
=GROWTH(B2:B10,A2:A10,B15)
16
11
\$30.75
=GROWTH(B2:B10,A2:A10,B16)
17
12
\$30.90
=GROWTH(B2:B10,A2:A10,B17,2)