Manuals/calci/GROWTH - Revision history

Devika at 22:08, 10 August 2018

2018-08-10T22:08:27Z

Devika at 23:29, 14 June 2018

2018-06-14T23:29:34Z

Devika at 21:29, 14 June 2018

2018-06-14T21:29:20Z

Devika: /* Description */

2018-06-14T21:20:22Z

Description

Devika at 21:17, 14 June 2018

2018-06-14T21:17:36Z

Devika: /* Description */

2018-06-14T21:16:08Z

Description

Devika at 21:14, 14 June 2018

2018-06-14T21:14:33Z

Jayaram at 07:28, 13 March 2017

2017-03-13T07:28:25Z

Swapna at 19:30, 24 June 2015

2015-06-24T19:30:31Z

Devika at 15:19, 11 May 2015

2015-05-11T15:19:25Z

@@ Line 4: / Line 4: @@
 *<math>NewXs</math> is the new x value.
 *<math>ForceConst</math> is the constant value.
-**GROWTH() Returns data stored in a PivotTable
+**GROWTH(), returns data stored in a PivotTable.

@@ Line 4: / Line 4: @@
 *<math>NewXs</math> is the new x value.
 *<math>ForceConst</math> is the constant value.
-**Returns data stored in a PivotTable
+**GROWTH() Returns data stored in a PivotTable

@@ Line 4: / Line 4: @@
 *<math>NewXs</math> is the new x value.
 *<math>ForceConst</math> is the constant value.
 ==Description==
 *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 (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,

@@ Line 6: / Line 6: @@
 ==Description==
 *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 (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,

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''GROWTH(y,x,x1,c)'''</div><br/>GROWTH (KnownYs,KnownXs,NewXs,ForceConst)
+<div style="font-size:30px">'''GROWTH (KnownYs,KnownXs,NewXs,ForceConst)'''</div><br/>
 *<math>KnownYs</math> is the set of y values.
 *<math>KnownXs</math> is the set of x values.

@@ Line 18: / Line 18: @@
 *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>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 1: / Line 1: @@
-<div style="font-size:30px">'''GROWTH(y,x,x1,c)'''</div><br/>
+<div style="font-size:30px">'''GROWTH(y,x,x1,c)'''</div><br/>GROWTH (KnownYs,KnownXs,NewXs,ForceConst)
-*<math> y</math> is the set of y values.
-*<math>x</math> is the set of x values.
+*<math>KnownYs</math> is the set of y values.
-*<math>x_1</math> is the new x value.
+*<math>KnownXs</math> is the set of x values.
-*<math>c</math> is the constant value.
+*<math>NewXs</math> is the new x value.
 ==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)</math>, <math>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.

← Older revision		Revision as of 07:28, 13 March 2017
Line 48:		Line 48:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Exponential_growth Growth]		*[http://en.wikipedia.org/wiki/Exponential_growth Growth]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 35: / Line 35: @@
 |}
 #GROWTH(A1:E1,A2:E2) = 2001.0811609385346   2001.862658527073   2003.0511194284027  2004.0133509635207    2004.991702115926
 ==See Also==

← Older revision		Revision as of 15:19, 11 May 2015
Line 44:		Line 44:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Exponential_growth Growth]		*[http://en.wikipedia.org/wiki/Exponential_growth Growth]
−	~~==References==~~