Excel Function : GROWTH
Returns values along an exponential trend
Microsoft Excel Reference Page
Syntax and Description of the GROWTH Excel Function
The GROWTH function in Excel calculates the trend line of a given data set using the least squares method and returns the predicted exponential growth based on this trend line. The syntax for the GROWTH function is as follows: GROWTH(known_y's, known_x's, [new_x's], [const]) where known_y's is the array or range of data points that contain the dependent variable values (y-values), known_x's is the array or range of data points that contain the independent variable values (x-values), [new_x's] is an optional array or range of data points that contain new independent variable values for which you want to
About GROWTH Excel Function
GROWTH(known_y's, [known_x's], new_x's, [const]) The GROWTH function predicts the exponential growth of one variable based on the natural growth rate of another variable. For example, you can use GROWTH to predict population growth based on birth rate.