Manuals/calci/GROWTH

GROWTH(y,x,x1,c)

• $y$ is the set of y values.
• $x$ is the set of x values.
• $x1$ is the new x value.
• $c$ is the constant value.

Description

• This function calculates an exponential trend of the $y$ values for new $x$ values by using given $x$ and $x$ 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(y,x,x1,c),y$ is the set of $y$ values used to predict the exponential growth, $x$ is the set of $x$ values used to predict the exponential growth,
• $x1$ is the set of new x-values, for which the function calculates corresponding new y-values and $c$ is the constant. It is either a TRUE or FALSE.
• When $c$ value is TRUE, then the constant value is calculated normally. When $c$ value is FALSE, then the constant is set to 1.
• Here $y$ value is required. $x,x1$ and $c$ is optional.
• If $x$ value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of $y$.
• If $x1$ value is omitted, then it is assumed to be the same size of $x$.
• If both $x$ and $x1$ are omitted, then they are assumed to be the array {1,2,3..} which is the same size of $y$.
• Also $x$ and $y$ values is the set of values with the relationship $y=b*mx$.
• When entering an array constant for an argument such as $x$, 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 $y$ value is 0 or negative.

Examples

Year population 2001 2002 2003 1100000110000011000001100000110000011000001100000110000011000001100000110000011000001100000110000011000001100000 2004 2005 GROWTH(B15:B19,C15:C19)=2001.081161

Spreadsheet

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

where, x , x1  and c 

GROWTH (N1, N2, n and C) in the relationship y = b*m^x

Where N1 is the set of y values, N2 is the set of x values, n is the new x values to the particular y values and C is the constant whether to force the constant b to equal 1

b is calculated normally when C is TRUE and is equal to 1 when C is FALSE.

---

 

Growth calculates an exponential trend of the y-values for new x-values by using the given x-values and y-values.

---

•  After selecting the correct number of cells, the formulas which calculate the arrays should be entered as array formulas. Use commas to separate the values in the same row and semicolons to separate rows.

---

GROWTH

---

Lets see an example,

B                  C

22               45000

23               52000

24               67000

25             115000

26             165000

27             225000

28

29

?UNIQ105c02ae06096ee1-nowiki-00000002-QINU?

---

Syntax

---

Remarks

---

Examples

---

Description

---

	Column1	Column2	Column3	Column4
Row1	22	45000	322408.3667147927,458726.1269057352
Row2	23	52000
Row3	24	67000
Row4	25	115000
Row5	26	165000
Row6	27	225000
Row7	28
Row8	29

File:Calci1.gif

---