Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu

SLOPE function


SLOPE(rangeX,rangeY) returns the slope of the regression line of rangeY (dependent data, Y) on rangeX (independent data, X).

The arguments rangeX and rangeY can be a list of numbers, cell addresses, cell ranges (such as A1:A10).

RangeX and rangeY can also be vectors (column or row matrices) with the same number of elements.

The equation for SLOPE b is:

$$ b = \frac{ \sum_{}^{}{(x-\bar{x})(y-\bar{y})}} {\sum_{}^{}{(x-\bar{x})^2}} $$

Note that in comparison with the corresponding Excel function, the order of the X and Y arguments is reversed.

Related functions