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:
where b, the slope, is calculated as:
Note that in comparison with the corresponding Excel function, the order of the X and Y arguments is reversed.