INTERCEPT function

INTERCEPT(yValues, xValues) INTERCEPT(yValues; xValues)

yValues — { Number }

The vertical values.

xValues — { Number }

The horizontal values.

Returns — Number

The intercept on the vertical axis.

Fits a straight line to data using linear regression and returns its intercept on the vertical axis.

Example

INTERCEPT({ 8, 9, 10, 11 }, { 50, 80, 110, 140 })INTERCEPT({ 8; 9; 10; 11 }; { 50; 80; 110; 140 })

Returns roughly 6.33.