Spread.NET 17 Formula Reference
Formula Functions / Functions D to G / GROWTH
In This Topic
    GROWTH
    In This Topic

    This function calculates predicted exponential growth. This function returns the y values for a series of new x values that are specified by using existing x and y values.

    Syntax

    GROWTH(y,x,newx,constant)

    Remarks

    This function has these arguments:

    Argument Description
    y Set of y values that are known in the relationship y=b*m^x
    x (Optional) X is an optional set of x values that may be known in the relationship y=b*m^x
    newx New x values for which this functions returns the corresponding y values
    constant Logical value that specifies whether to force the constant b to equal 1

    If constant is true or omitted then b is calculated normally. If constant is false then b is equal to 0 and the m values are adjusted so that y=m^x.

    If x is omitted then x defaults to the array {1,2,3...}, that has the same dimensions as y.

    If newx is omitted then it defaults to x.

    Remarks

    Use the INDEX function to get individual elements from the returned array.

    Data Types

    Accepts an array. Returns an array.

    Examples

    GROWTH(A2:A7,C2:C7,A9:A10)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    AVEDEV | AVERAGEA | FREQUENCY | DEVSQ | MEDIAN | TREND | VAR | Statistical Functions