Manuals/calci/GROWTH
Jump to navigation
Jump to search
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
=GROWTH(C2:C7,B2:B7,B8:B9) is 322408.3667 and 458726.12691
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 |
