Excel: Growth Function

In Excel, the Growth function returns the predicted exponential growth based on existing values provided.

The syntax for the Growth function is:

Growth( known_y_values, known_x_values, new_x_values, constant )

known_y_values is the known y-values used to predict the exponential growth.

known_x_values is optional. It is the known x-values used to predict the exponential growth. If this parameter is omitted, the Growth function uses {1,2,3,...} as the known_x_values parameter.

new_x_values is optional. It is the x-values that are used by the Growth function to return the corresponding y-values. If this parameter is omitted, the Growth function uses {1,2,3,...} as the new_x_values parameter.

constant is either a TRUE or FALSE value. TRUE means that the constant b is calculated normally. FALSE means that the constant b is set to 1. If this parameter is omitted, the Growth function assumes a constant parameter of TRUE.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Growth({4,5,6}) would return 4.027307453

=Growth({4,5,6}, {10,20,30}) would return 4.027307453

=Growth({4,5,6}, {10,20,30}, {15,30,45}) would return 4.456948343

=Growth({4,5,6}, {10,20,30}, {15,30,45}, FALSE) would return 2.913437857

=Growth(B2:B6, A2:A6) would return 7.344380549