Intercept (y-value at x = 0) of a linear regression line.
Syntax:
INTERCEPT( y‑data:Range or Array, x‑data:Range or Array )
Returns the intercept of the linear regression line given by the y‑data array and x‑data array.
Note:
INTERCEPT()
is implemented using a two-pass approach, first independently computing the mean values,
then computing intermediate values (such as the sum of the squares, products) using the difference between each value and the corresponding mean value.
This approach helps avoid many round-off errors and is also employed by Microsoft Excel 2003 and later.
Revisions:
This function was added in 2.00.