Difference between revisions of "Manuals/calci/GROWTH"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
*<math> y</math> is the set of y values. | *<math> y</math> is the set of y values. | ||
*<math>x</math> is the set of x values. | *<math>x</math> is the set of x values. | ||
| − | *<math> | + | *<math>x_1</math> is the new x value. |
*<math>c</math> is the constant value. | *<math>c</math> is the constant value. | ||
| Line 9: | Line 9: | ||
*This function calculates an exponential trend of the <math> y</math> values for new <math> x</math> values by using given <math> x</math> and <math> x</math> values. | *This function calculates an exponential trend of the <math> y</math> values for new <math> x</math> values by using given <math> x</math> and <math> x</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. | *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, | + | *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, |
| − | *<math> | + | *<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. |
* 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> 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. | ||
| − | *Here <math> y</math> value is required. <math> x, | + | *Here <math> y</math> value is required. <math> x,x_1</math> and <math>c</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>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> | + | *If <math>x_1</math> value is omitted, then it is assumed to be the same size of <math>x</math>. |
| − | *If both <math> x</math> and <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>. |
*Also <math> x</math> and <math> y</math> values is the set of values with the relationship <math>y=b*mx</math>. | *Also <math> x</math> and <math> y</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>x</math>, use commas to separate values in the same row and semicolons to separate rows. | ||
Revision as of 02:53, 15 January 2014
GROWTH(y,x,x1,c)
- is the set of y values.
- is the set of x values.
- is the new x value.
- is the constant value.
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 new 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.
is the set of 
and 
.
Examples
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 2001 | 2002 | 2003 | 2004 | 2005 |
| 2 | 1000000 | 1100000 | 1252000 | 1375000 | 1500000 |
- GROWTH(A1:E1,A2:E2) = 1.0000000039046144