Difference between revisions of "Manuals/calci/GROWTH"

Latest revision as of 17:08, 10 August 2018

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.

Examples

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

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

References

Growth

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''GROWTH(y,x,x1,c)'''</div><br/>
+<div style="font-size:30px">'''GROWTH (KnownYs,KnownXs,NewXs,ForceConst)'''</div><br/>
-*<math> y</math>   is the set of y values.
+*<math>KnownYs</math> is the set of y values.
-*<math>x</math>  is the set of x values.
+*<math>KnownXs</math> is the set of x values.
-*<math>x_1</math> is the new x value.
+*<math>NewXs</math> is the new x value.
-*<math>c</math> is the constant value.
+*<math>ForceConst</math> is the constant value.
+**GROWTH(), returns data stored in a PivotTable.
 ==Description==
-*This function calculates an exponential trend of the <math> y</math> values for new <math> x</math> values by using given <math> y</math> and <math> x</math> values.
+*This function calculates an exponential trend of the <math> KnownYs</math> values for  <math> NewXs</math> values by using given <math> KnownYs</math> and <math> KnownXs</math> 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 <math>GROWTH(y,x,x_1,c), y </math> is the set of <math>y</math> values used to predict the exponential growth, <math> x</math> is the set of <math> x</math> values used to predict the exponential growth,
+*In <math>GROWTH (KnownYs,KnownXs,NewXs,ForceConst)</math>, <math>KnownYs </math> is the set of <math>y</math> values used to predict the exponential growth, <math> KnownXs</math> is the set of <math> x</math> values used to predict the exponential growth,
-*<math> x_1</math> is the set of new x-values, for which the function calculates corresponding new y-values and <math>c</math> is the constant. It is either a TRUE or FALSE.
+*<math> NewXs</math> is the set of new x-values, for which the function calculates corresponding new y-values and <math>ForceConst</math> is the constant. It is either a TRUE or FALSE.
-* When <math> c</math> value is TRUE, then the constant value is calculated normally. When <math> c</math> value is FALSE, then the constant is set to 1.
+*When <math> ForceConst</math> value is TRUE, then the constant value is calculated normally. When <math> c</math> value is FALSE, then the constant is set to 1.
-*Here  <math> y</math> value is required. <math> x,x_1</math> and <math>c</math> is optional.
+*Here  <math> KnownYs</math> value is required. <math> KnownXs,NewXs</math> and <math>ForceConst</math> is optional.
-*If <math>x</math> value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of <math>y</math>.
+*If <math>KnownXs</math> value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of <math>KnownYs</math>.
-*If  <math>x_1</math> value is omitted, then it is assumed to be the same size of <math>x</math>.
+*If  <math>NewXs</math> value is omitted, then it is assumed to be the same size of <math>KnownXs</math>.
-*If both <math> x</math> and <math> x_1</math> are omitted, then they are assumed to be the array {1,2,3..} which is the same size of <math> y</math>.
+*If both <math> KnownXs</math> and <math> NewXs</math> are omitted, then they are assumed to be the array {1,2,3..} which is the same size of <math> KnownYs</math>.
-*Also <math> x</math> and <math> y</math> values is the set of values with the relationship <math>y=b*mx</math>.
+*Also <math> KnownXs</math> and <math> KnownYs</math> values is the set of values with the relationship <math>y=b*mx</math>.
-*When entering an array constant for an argument such as <math>x</math>, use commas to separate values in the same row and semicolons to separate rows.
+*When entering an array constant for an argument such as <math>KnownXs</math>, 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 <math>y</math> value is 0 or negative.
+*This function will return the result as error when any one of the value in <math>KnownYs</math> value is 0 or negative.
 ==Examples==
@@ Line 35: / Line 36: @@
 |}
-#GROWTH(A1:E1,A2:E2) = 1.0000000039046144
+#GROWTH(A1:E1,A2:E2) = 2001.0811609385346   2001.862658527073   2003.0511194284027  2004.0133509635207    2004.991702115926
+==Related Videos==
+{{#ev:youtube|fp5yFpzAJ7g|280|center|GROWTH}}
 ==See Also==
+*[[Manuals/calci/LOGEST| LOGEST]]
+*[[Manuals/calci/LINEST| LINEST]]
+*[[Manuals/calci/TREND| TREND]]
 ==References==
+*[http://en.wikipedia.org/wiki/Exponential_growth Growth]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/GROWTH"

Latest revision as of 17:08, 10 August 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search