Difference between revisions of "Documentation/How Tos/Calc: GROWTH function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (talk | contribs) |
Javier Lopez (talk | contribs) |
||
Line 1: | Line 1: | ||
+ | {{Documentation/MasterTOC | ||
+ | |bookid=1234''' | ||
+ | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | ||
+ | |ShowParttitle=block | ||
+ | |parttitle=[[Documentation/How_Tos/Calc:_Array_functions|<div style="font-size: 140%;">Arrays Functions]] | ||
+ | |ShowNextPage=block | ||
+ | |NextPage=Documentation/How_Tos/Calc:_GROWTH_function | ||
+ | |ShowPrevPage=block | ||
+ | |PrevPage= Documentation/How_Tos/Calc:_Array_functions | ||
+ | |ShowPrevPart=block | ||
+ | |PrevPart= Documentation/Reference/Calc_functions | ||
+ | |ShowNextPart=block | ||
+ | |NextPart= Documentation/How_Tos/Calc:_Complex_Number_functions | ||
+ | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | ||
+ | |||
+ | * [[Documentation/How_Tos/Calc:_FREQUENCY_function|<div style="font-size: 120%;">Frequency]] | ||
+ | * [[Documentation/How_Tos/Calc:_GROWTH_function|<div style="font-size: 120%; | ||
+ | border-style: double; border-color:#778899;">Growth</div>]] | ||
+ | * [[Documentation/How_Tos/Calc:_LINEST_function|<div style="font-size: 120%;">Linest]] | ||
+ | * [[Documentation/How_Tos/Calc:_LOGEST_function|<div style="font-size: 120%;">Longest]] | ||
+ | * [[Documentation/How_Tos/Calc:_MDETERM_function|<div style="font-size: 120%;">Mdeterm]] | ||
+ | * [[Documentation/How_Tos/Calc:_MINVERSE_function|<div style="font-size: 120%;">Minverse]] | ||
+ | * [[Documentation/How_Tos/Calc:_MMULT_function|<div style="font-size: 120%;">Mmult]] | ||
+ | * [[Documentation/How_Tos/Calc:_MUNIT_function|<div style="font-size: 120%;">Munit]] | ||
+ | * [[Documentation/How_Tos/Calc:_SUMPRODUCT_function|<div style="font-size: 120%;">Sumproduct]] | ||
+ | * [[Documentation/How_Tos/Calc:_SUMX2MY2_function|<div style="font-size: 120%;">vSumx2my2]] | ||
+ | * [[Documentation/How_Tos/Calc:_SUMX2PY2_function|<div style="font-size: 120%;">Sumx2py2]] | ||
+ | * [[Documentation/How_Tos/Calc:_SUMXMY2_function|<div style="font-size: 120%;">Sumxmy2]] | ||
+ | * [[Documentation/How_Tos/Calc:_TRANSPOSE_function|<div style="font-size: 120%;">Transpose]] | ||
+ | * [[Documentation/How_Tos/Calc:_TREND_function|<div style="font-size: 120%;">Trend]] | ||
+ | }} | ||
__TOC__ | __TOC__ | ||
Revision as of 22:19, 5 May 2013
CALC FUNCTIONS
< {{#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 Cntrl-Shift-Enter rather than just Enter).
- 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).