Spread.NET 17 Formula Reference
Formula Functions / Functions H to L / LINEST
In This Topic
    In This Topic

    This function calculates the statistics for a line.




    The equation for the line is y=mx+b or y=m1x1+m2x2+...+b.

    This function has these arguments:

    Argument Description
    y Set of y values that are known in the relationship y=mx+b
    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=mx.
    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.



    Version Available

    This function is available in product version 2.0 or later.

    See Also

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