Manuals/calci/GROWTH

GROWTH(y,x,x1,c)

• $y$ is the set of y values.
• $x$ is the set of x values.
• $x_{1}$ is the new x value.
• $c$ is the constant value.

Description

• This function calculates an exponential trend of the $y$ values for new $x$ values by using given $y$ and $x$ values.
• Growth rate is a financial term used to describe a method of projecting the rate of return on a given investment over a period of time.
• In $GROWTH(y,x,x_{1},c)$, $y$ is the set of $y$ values used to predict the exponential growth, $x$ is the set of $x$ values used to predict the exponential growth,
• $x_{1}$ is the set of new x-values, for which the function calculates corresponding new y-values and $c$ is the constant. It is either a TRUE or FALSE.
• When $c$ value is TRUE, then the constant value is calculated normally. When $c$ value is FALSE, then the constant is set to 1.
• Here $y$ value is required. $x,x_{1}$ and $c$ is optional.
• If $x$ value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of $y$.
• If $x_{1}$ value is omitted, then it is assumed to be the same size of $x$.
• If both $x$ and $x_{1}$ are omitted, then they are assumed to be the array {1,2,3..} which is the same size of $y$.
• Also $x$ and $y$ values is the set of values with the relationship $y=b*mx$.
• When entering an array constant for an argument such as $x$, use commas to separate values in the same row and semicolons to separate rows.
• This function will return the result as error when any one of the value in $y$ value is 0 or negative.

Examples

Spreadsheet

	A	B	C	D	E
1	2001	2002	2003	2004	2005
2	1000000	1100000	1252000	1375000	1500000

1. GROWTH(A1:E1,A2:E2) = 2001.0811609385346 2001.862658527073 2003.0511194284027 2004.0133509635207 2004.991702115926

See Also

• LOGEST
• LINEST
• TREND

References

• Growth