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.