INTERCEPT
Returns the intercept of the linear regression line.
StatisticalStatistics & Analysis
What it does
Calculates the point where a linear regression line intersects the y-axis.
Syntax
INTERCEPT(known_y's, known_x's)
Arguments
known_y's(range) — Dependent set.known_x's(range) — Independent set.
Examples
Linear Intercept
Find y-intercept.
FORMULA
=INTERCEPT(B2:B4, A2:A4)
RESULT
0
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | X | Y |
| 2 | 1 | 2 |
| 3 | 2 | 4 |
| 4 | 3 | 6 |