SheetFX
≡
<< Go back to all functions

GROWTH

The GROWTH function in Google Sheets is a powerful tool for fitting an ideal exponential growth trend based on partial data and predicting further values. Whether you're analyzing population growth, financial investments, or scientific experiments, the GROWTH function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

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

Parameters:

  • known_data_y: The known y-values that represent the dependent variable data points.
  • known_data_x: [Optional] The known x-values that represent the independent variable data points.
  • new_data_x: [Optional] The new x-values for which you want to predict the corresponding y-values.
  • b: [Optional] A logical value that specifies whether to force the constant b to equal 1 in the equation y = b * m^x. Default is FALSE.

Step-by-Step Tutorial

  1. Using GROWTH with only known y-values:

    • Example: =GROWTH(A1:A5)
    • Result: An exponential growth trend is fitted based on the known y-values.

  2. Using GROWTH with known y and x-values:

    • Example: =GROWTH(B1:B5, A1:A5)
    • Result: An exponential growth trend is fitted based on the known y and x-values. The x-values represent the independent variable.

  3. Predicting y-values using GROWTH:

    • Example: =GROWTH(A1:A5, B1:B5, C1:C3)
    • Result: The formula predicts the y-values corresponding to the new x-values.

Use Cases and Scenarios

  1. Population Growth Forecast: Predict future population numbers based on historical data.
  2. Investment Growth Projection: Estimate the future value of an investment using historical growth rates.
  3. Scientific Experiment Modeling: Fit an exponential growth equation to experimental data and analyze the trend.

Related Functions

  • LINEST: Calculate statistics for a straight line (linear regression) that best fits a data set.
  • TREND: Calculates values along a linear trend using least squares regression.

Related Articles