INTERCEPT

Try it

When to use it

When should I use INTERCEPT?

Use INTERCEPT to find the y-intercept of the least-squares regression line through known data points, which represents the predicted y-value when x equals zero.

Used in

science · operations

Syntax

INTERCEPT(known_y,known_x)

Examples

=INTERCEPT({2,3,9,1,8},{6,5,11,7,5}) // => 0.04838709677419306