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.