How to use the GROWTH function
What is the GROWTH function?
The GROWTH function returns estimated exponential growth based on given data. It calculates the y-values for new x-values based on existing x and y-values, see the following formula and the image above.
What is exponential growth?
Exponential growth is a process that increases a quantity over time at a rate that is proportional to the quantity itself. For example, if you have a population of rabbits that doubles every 6 months, then the number of rabbits will grow exponentially as time passes.
Exponential growth can be described by a mathematical function of the form y = abx, where y is the quantity, a is the initial value, b is the growth factor, and x is the time.
The graph of an exponential function is always a curve that rises or falls rapidly, depending on whether the growth factor is greater or less than one.
Related functions
Function | Description |
---|---|
POWER(number, power) | Calculates a number raised to a power. |
GROWTH(known_y's, [known_x's], [new_x's], [const]) | Returns predicted y-values for exponential growth trend. |
EXP(number) | Â Returns e raised to the power of a given number. |
GROWTH function Syntax
GROWTH(known_y's, [known_x's], [new_x's], [const])
GROWTH function Arguments
known_y's | Required. Y-values you want to use. |
[known_x's] | Optional. X-values you want to use. |
[new_x's] | Optional. The GROWTH function uses these values to calculate the corresponding y-values. |
[const] | Optional. Boolean value that determines whether to force the constant b to be 1. TRUE - b is calculated. (Default value). FALSE - b is equal to 1 and m-values are adjusted. |
GROWTH function example 1
The GROWTH function allows you to fit exponential values to existing x and y-values.
Array formula in cell D3:D13:
To enter an array formula select cell range D3:D13, type the formula and then press and hold CTRL + SHIFT simultaneously, now press Enter once. Release all keys.
The formula bar now shows the formula with a beginning and ending curly bracket telling you that you entered the formula successfully.
Don't enter the curly brackets yourself, they appear automatically.
GROWTH function example 2
Array formula in cell B15:B16:
How is the GROWTH function calculated
The relationship used is
y=b*m^x
if [const] is TRUE
and y=m^x
if [const] is FALSE.
Functions in 'Statistical' category
The GROWTH function function is one of 74 functions in the 'Statistical' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form