INTERCEPT

Name

INTERCEPT —
INTERCEPT(known_y's,known_x's)

Description

INTERCEPT function calculates the point where the linear regression line intersects the y-axis.

If @known_x or @known_y contains no data entries or different number of data entries, INTERCEPT returns #N/A! error. If the variance of the @known_x is zero, INTERCEPT returns #DIV/0 error.

See also

FORECAST , TREND