Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / WorksheetFunction Class / Growth Method
The set of y-values you already know in the relationship y = b*m^x.
An optional set of x-values that you may already know in the relationship y = b*m^x.
New x-values for which you want GROWTH to return corresponding y-values.
A logical value specifying whether to force the constant b to equal 1.
The context worksheet to calculate.
The context row to calculate.
The context column to calculate.


In This Topic
Growth Method
In This Topic
Calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an exponential curve to existing x-values and y-values.
Syntax
'Declaration
 
Public Function Growth( _
   ByVal knowY As Object, _
   Optional ByVal knowX As Object, _
   Optional ByVal newX As Object, _
   Optional ByVal constant As Object, _
   Optional ByVal worksheet As IWorksheet, _
   Optional ByVal contextRow As Integer, _
   Optional ByVal contextColumn As Integer _
) As Object
 
'Usage
 
Dim instance As WorksheetFunction
Dim knowY As Object
Dim knowX As Object
Dim newX As Object
Dim constant As Object
Dim worksheet As IWorksheet
Dim contextRow As Integer
Dim contextColumn As Integer
Dim value As Object
 
value = instance.Growth(knowY, knowX, newX, constant, worksheet, contextRow, contextColumn)

Parameters

knowY
The set of y-values you already know in the relationship y = b*m^x.
knowX
An optional set of x-values that you may already know in the relationship y = b*m^x.
newX
New x-values for which you want GROWTH to return corresponding y-values.
constant
A logical value specifying whether to force the constant b to equal 1.
worksheet
The context worksheet to calculate.
contextRow
The context row to calculate.
contextColumn
The context column to calculate.
See Also