Description Computes the y-intercept of the least squares linear regression line through the given data.
Syntax INTERCEPT (arrayY, arrayX)
| Argument | Description |
|---|---|
| arrayY and arrayX | A range reference or an array constant containing numeric values. ArrayX and arrayY must contain the same potential number of values.Text, logical values, and empty cells referenced by this function are ignored, along with the number they are paired up with. That is, when a number from arrayX is paired up with text from arrayY, the entire pair is ignored. |
Remarks This function pairs up the numbers in the two ranges by moving left-to-right through each sequential row.
Equation
where b is the slope and n is the number of members in arrayY and arrayX.
Examples This function returns 2.142857143:
