Spread Windows Forms 17
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