INTERCEPT

Definition: INTERCEPT is a function that returns the y-intercept of a linear regression line.

Syntax: =INTERCEPT(known_y’s, known_x’s)

Situation: This formula is suitable when you need to find the y-intercept of a linear regression line.

Example: If you have a set of known x and y values, the y-intercept of the regression line can be found using the formula =INTERCEPT(B1:B10, A1:A10).