Difference between revisions of "Manuals/calci/GROWTH"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">'''GROWTH (N1, N2, n and C) in the relationship y = b*m^x'''</font></font...") |
|||
| (17 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <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. | ||
| + | *<math>NewXs</math> is the new x 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> 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, | ||
| + | *<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> 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> KnownYs</math> value is required. <math> KnownXs,NewXs</math> and <math>ForceConst</math> is optional. | ||
| + | *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>NewXs</math> value is omitted, then it is assumed to be the same size of <math>KnownXs</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> 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>KnownYs</math> value is 0 or negative. | ||
| − | + | ==Examples== | |
| + | |||
| − | + | {| class="wikitable" | |
| − | --- | + | |+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 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==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 ]] | |
| − | |||
Latest revision as of 17:08, 10 August 2018
GROWTH (KnownYs,KnownXs,NewXs,ForceConst)
- is the set of y values.
- is the set of x values.
- is the new x value.
- is the constant value.
- GROWTH(), returns data stored in a PivotTable.
is the set of y values.
is the set of x values.
is the new x value.
is the constant value.
Description
- This function calculates an exponential trend of the values for values by using given and 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 , is the set of values used to predict the exponential growth, is the set of values used to predict the exponential growth,
- is the set of new x-values, for which the function calculates corresponding new y-values and is the constant. It is either a TRUE or FALSE.
- When value is TRUE, then the constant value is calculated normally. When value is FALSE, then the constant is set to 1.
- Here value is required. and is optional.
- If value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of .
- If value is omitted, then it is assumed to be the same size of .
- If both and are omitted, then they are assumed to be the array {1,2,3..} which is the same size of .
- Also and values is the set of values with the relationship .
- When entering an array constant for an argument such as , 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 value is 0 or negative.
, 
values used to predict the exponential growth, 
values used to predict the exponential growth,
value is FALSE, then the constant is set to 1.
and 
.Examples
| 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
Related Videos
See Also
References