INTERCEPT

INTERCEPT the intercept of a linear regression line

Synopsis

INTERCEPT(known_ys,known_xs)

Arguments

known_ys: known y-values

known_xs: known x-values

Note

If known_xs or known_ys contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the known_xs is zero, this function returns #DIV/0 error.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

FORECAST, TREND.