Difference between revisions of "Documentation/How Tos/Calc: GROWTH function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{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:_LINEST_function
 +
|ShowPrevPage=block
 +
|PrevPage= Documentation/How_Tos/Calc:_FREQUENCY_function
 +
|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__
  
 
== GROWTH ==
 
== GROWTH ==
Line 23: Line 54:
 
<br style="clear:both;" />
 
<br style="clear:both;" />
  
−
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
−
* [[Documentation/How_Tos/Calc: TREND function|TREND]],
+
* [[Documentation/How_Tos/Calc: TREND function|TREND]]
 
* [[Documentation/How_Tos/Calc: LOGEST function|LOGEST]]
 
* [[Documentation/How_Tos/Calc: LOGEST function|LOGEST]]
  
Line 33: Line 64:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Array functions]]
 +
[[Category: Documentation/Reference/Calc/Statistical functions]]

Revision as of 08:40, 17 July 2018


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:

Calc growth example.png

=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).



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_GROWTH_function&oldid=243498"
Views
Personal tools
Navigation
Tools