# INTERCEPT function

## Description

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.