GROWTH Function Explained
The GROWTH function in Microsoft Excel is used to calculate the predicted exponential growth based on existing data. It takes up to five arguments: known_y's, known_x's, new_x's, const, and stats. The known_y's argument is a range of dependent values, known_x's is a range of independent values, new_x's is a range of new independent values for which you want to predict the growth, const is a logical value that specifies whether to force the constant b to equal 0, and stats is a logical value that specifies whether to return additional regression statistics. The GROWTH function returns the predicted exponential growth values for the new x-values.
GROWTH Function Syntax
GROWTH(known_y's, [known_x's], [new_x's], [const])
- known_y’s: An array of y-values that you already know in the relationship y = b*m^x.
- known_x’s: An array of x-values that you already know in the relationship y = b*m^x. This argument is optional.
- new_x’s: An array of new x-values for which you want to predict the corresponding y-values.
- const: A logical value that determines the form of the regression. If const is TRUE or omitted, b is calculated normally. If const is FALSE, b is set equal to 0 and the m-value is calculated normally.