SpreadJS 14
Formula Reference / Formula Functions / Statistical Functions / LOGEST
In This Topic
    In This Topic

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




    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.


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

    Data Types

    Accepts an array. Returns an array.



    See Also