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.