Spread Formula Reference
Formula Functions / Functions H to L / LOGEST
In This Topic
    LOGEST
    In This Topic

    This function calculates an exponential curve that fits the data and returns an array of values that describes the curve.

    Syntax

    LOGEST(y,x,constant,stats)

    Arguments

    The equation for the curve is y=b*m^x or y=(b*(m1^x1)*(m2^x2)*_).

    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=mx+b
    constant Logical value that specifies whether to force the constant b to equal 0. If true or omitted then b is calculated normally; if false then b is equal to 0 and the m values are adjusted so that y=m^x.
    stats Logical value that specifies whether to return additional regression statistics. If true, then the additional regression statistics are returned if false or omitted then only the m-coefficients and b are returned.

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

    Remarks

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

    Data Types

    Accepts an array. Returns an array.

    Examples

    LOGEST(A2:A7,C2:C7,TRUE,FALSE)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    GROWTH | TREND | LINEST | DEVSQ | MEDIAN | VAR | Statistical Functions