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.
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 $KnownYs$ value is 0 or negative.