Spread Formula Reference
Formula Functions / Functions R to S / SLOPE
In This Topic
    SLOPE
    In This Topic

    This function calculates the slope of a linear regression.

    Syntax

    SLOPE(array_dep,array_ind)

    Arguments

    This function has these arguments:

    Argument Description
    array_dep Array of dependent values (y’s)
    array_ind Array of independent values (x’s)

    The arrays must be the same size.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    SLOPE(A1:A4,B1:B4)

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    SERIESSUM | Math and Trigonometry Functions