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 Show menu

INTERCEPT function


INTERCEPT(rangeX,rangeY) returns the intercept 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 INTERCEPT a is:

$$ a = \bar{y} - b \bar{x} $$

where b, the slope, is calculated as:

$$ 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