INTERCEPT (YValues, XValues) INTERCEPT (YValues; XValues)
YValues
The vertical values.
XValues
The horizontal values.
Returns
Number Number
The intercept on the vertical axis.
Fits a straight line to data using linear regression and returns its intercept on the vertical axis. This is the vertical coordinate at which the line crosses the vertical axis, where the horizontal coordinate is 0. Use SLOPE for the slope of the same line.
Example
INTERCEPT ({ 8, 9, 10, 11 }, { 50, 80, 110, 140 })
INTERCEPT ({ 8; 9; 10; 11 }; { 50; 80; 110; 140 })
Returns roughly 6.33.