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 As Object, _
Optional ByVal As Object, _
Optional ByVal As Object, _
Optional ByVal As Object, _
Optional ByVal As IWorksheet, _
Optional ByVal 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