Manuals/calci/GROWTH

GROWTH (KnownYs,KnownXs,NewXs,ForceConst)

• $KnownYs$ is the set of y values.
• $KnownXs$ is the set of x values.
• $NewXs$ is the new x value.
• $ForceConst$ is the constant value.
  • GROWTH(), returns data stored in a PivotTable.

Description

• This function calculates an exponential trend of the $KnownYs$ values for $NewXs$ values by using given $KnownYs$ and $KnownXs$ 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(KnownYs,KnownXs,NewXs,ForceConst)$, $KnownYs$ is the set of $y$ values used to predict the exponential growth, $KnownXs$ is the set of $x$ values used to predict the exponential growth,
• $NewXs$ is the set of new x-values, for which the function calculates corresponding new y-values and $ForceConst$ is the constant. It is either a TRUE or FALSE.
• When $ForceConst$ value is TRUE, then the constant value is calculated normally. When $c$ value is FALSE, then the constant is set to 1.
• Here $KnownYs$ value is required. $KnownXs,NewXs$ and $ForceConst$ is optional.
• If $KnownXs$ value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of $KnownYs$.
• If $NewXs$ value is omitted, then it is assumed to be the same size of $KnownXs$.
• If both $KnownXs$ and $NewXs$ are omitted, then they are assumed to be the array {1,2,3..} which is the same size of $KnownYs$.
• Also $KnownXs$ and $KnownYs$ values is the set of values with the relationship $y=b*mx$.
• When entering an array constant for an argument such as $KnownXs$, 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownYs} 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

Related Videos

GROWTH

See Also

• LOGEST
• LINEST
• TREND

References

• Growth

• List of Main Z Functions

• Z3 home