GROWTH

Formulas / GROWTH
Calculate predicted exponential growth.
GROWTH(known_y's, [known_x's], [new_x's], [const])
  • known_y's - required argument
  • known_x's - [OPTIONAL] argument
  • new_x's - [OPTIONAL] argument
  • const - [OPTIONAL] logical value

Examples

    The GROWTH function can be used to calculate the y-values for a series of new x-values. For example, if you have the known_x's in B2:B7 and the new_x's in A2:A7, then you can use the following formula:

  • =GROWTH(B2:B7,A2:A7)

    This will calculate the y-values for the series of new x-values specified by the known_x's and new_x's arguments.

  • The GROWTH function can be used to calculate the y-values for a series of new x-values with a specific equation. For example, if you want to calculate the y-values for a series of new x-values according to the equation B2+B7*A2+A7*B2, then you can use the following formula:

  • =GROWTH(B2:B7,A2:A7,B2+B7*A2+A7*B2)

    This will calculate the y-values for the series of new x-values specified by the known_x's, new_x's, and equation arguments.

  • The GROWTH function can be used to calculate the y-values for a series of new x-values with a specific equation and a specific set of known_x's. For example, if you have the known_x's in B2:B7 and the new_x's in A2:A7 and you want to calculate the y-values for a series of new x-values according to the equation B2+B7*A2+A7*B2, then you can use the following formula:

  • =GROWTH(B2:B7,A2:A7,B2+B7*A2+A7*B2,FALSE)

    This will calculate the y-values for the series of new x-values specified by the known_x's, new_x's, and no constant.

Summary

The GROWTH function is a powerful tool used to calculate the y-values associated with a given set of x-values. It helps to quickly and accurately generate data points for analysis.

  • The GROWTH function returns predicted exponential growth based on existing data and known y-values.
  • The new_x's argument is used to get corresponding y-values for new x-values.


Frequently Asked Questions

What is the GROWTH function?
The GROWTH function is a feature of Sourcetable that returns predicted exponential growth based on existing data.
What type of data does GROWTH use?
GROWTH uses existing data to return predicted exponential growth.
What are some of the uses for GROWTH?
  • Analyzing growth trends in business
  • Predicting future growth in a given market
  • Identifying areas of potential growth
  • Comparing growth between different areas
How accurate is GROWTH?
The accuracy of GROWTH depends on the quality of the data that it is using. The more accurate and complete the data, the more reliable the results will be.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.