Difference between revisions of "Documentation/How Tos/Calc: GROWTH function"
m |
m |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | {{DISPLAYTITLE:GROWTH function}} | ||
{{Documentation/CalcFunc ArraysTOC | {{Documentation/CalcFunc ArraysTOC | ||
|ShowPrevNext=block | |ShowPrevNext=block | ||
| Line 15: | Line 16: | ||
: If <tt>'''allow_factor'''</tt> is <tt>'''FALSE'''</tt> the factor ''b'' in this equation is set to <tt>'''1'''</tt>; if <tt>'''allow_factor'''</tt> is non-zero, <tt>'''TRUE'''</tt> or omitted the factor ''b'' is calculated from the data. | : If <tt>'''allow_factor'''</tt> is <tt>'''FALSE'''</tt> the factor ''b'' in this equation is set to <tt>'''1'''</tt>; if <tt>'''allow_factor'''</tt> is non-zero, <tt>'''TRUE'''</tt> or omitted the factor ''b'' is calculated from the data. | ||
| − | : <tt>'''GROWTH'''</tt> returns an array of the y values of the exponential curve found, corresponding to the x values in <tt>'''new_xvalues'''</tt> (or if omitted <tt>'''xvalues'''</tt>). It must be entered as an array formula (for example by using | + | : <tt>'''GROWTH'''</tt> returns an array of the y values of the exponential curve found, corresponding to the x values in <tt>'''new_xvalues'''</tt> (or if omitted <tt>'''xvalues'''</tt>). It must be entered as an array formula (for example by using {{key|Cntrl|Shift|Enter}} rather than just {{key|Enter}}). |
: <tt>'''yvalues'''</tt> and <tt>'''xvalues'''</tt> must be the same size. <tt>'''new_xvalues'''</tt> may have a different size. | : <tt>'''yvalues'''</tt> and <tt>'''xvalues'''</tt> must be the same size. <tt>'''new_xvalues'''</tt> may have a different size. | ||
=== Example: === | === Example: === | ||
| − | [[Image:Calc_growth_example.png| | + | [[Image:Calc_growth_example.png|center]] |
| + | |||
<tt>'''=GROWTH(B2:B6; A2:A6; A2:A7)'''</tt> | <tt>'''=GROWTH(B2:B6; A2:A6; A2:A7)'''</tt> | ||
: when entered as an array formula in cell C2, where the x values in A2:A7 are 4, 5, 6, 7, 8, 9 and the y values in B2:B6 are 1.80, 3.20, 6.20, 12.30, 24.50, finds a best fit exponential curve for those points, and in C2:C7 returns y values on that curve for the x values in A2:A7. | : when entered as an array formula in cell C2, where the x values in A2:A7 are 4, 5, 6, 7, 8, 9 and the y values in B2:B6 are 1.80, 3.20, 6.20, 12.30, 24.50, finds a best fit exponential curve for those points, and in C2:C7 returns y values on that curve for the x values in A2:A7. | ||
Latest revision as of 11:11, 30 January 2024
| [[{{{PrevPage}}}|< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page |
}} ]] |
{{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
GROWTH
Fits an exponential curve to a data set, and returns points on that curve.
Syntax:
GROWTH(yvalues; xvalues; new_xvalues; allow_factor)
- data is a range or array containing numerical data.
- yvalues and xvalues are single row or column ranges specifying points in a set of data.
- GROWTH fits an exponential curve of the form y=bmx through these data points, using the linear regression method.
- If allow_factor is FALSE the factor b in this equation is set to 1; if allow_factor is non-zero, TRUE or omitted the factor b is calculated from the data.
- GROWTH returns an array of the y values of the exponential curve found, corresponding to the x values in new_xvalues (or if omitted xvalues). It must be entered as an array formula (for example by using {{#switch:cntrl
| shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = Cntrl }} {{#if:Shift| + {{#switch:shift | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = Shift }} }}{{#if:Enter| + {{#switch:enter | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = Enter }} }}{{#if:| + {{#switch:{{{4}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{4}}} }} }}{{#if:| + {{#switch:{{{5}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{5}}} }} }}{{#if:| + {{#switch:{{{6}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{6}}} }} }} rather than just {{#switch:enter | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = Enter }} {{#if:| + {{#switch:{{{2}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{2}}} }} }}{{#if:| + {{#switch:{{{3}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{3}}} }} }}{{#if:| + {{#switch:{{{4}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{4}}} }} }}{{#if:| + {{#switch:{{{5}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{5}}} }} }}{{#if:| + {{#switch:{{{6}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{6}}} }} }}).
- yvalues and xvalues must be the same size. new_xvalues may have a different size.
Example:
=GROWTH(B2:B6; A2:A6; A2:A7)
- when entered as an array formula in cell C2, where the x values in A2:A7 are 4, 5, 6, 7, 8, 9 and the y values in B2:B6 are 1.80, 3.20, 6.20, 12.30, 24.50, finds a best fit exponential curve for those points, and in C2:C7 returns y values on that curve for the x values in A2:A7.
- This example shows how GROWTH may be used to predict future values (A7,C7).
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}
