Manuals/calci/INTERCEPT
INTERCEPT(Y,X)
Where Y is the dependent set of observations or data, and
Y is the independent set of observations or data.
This function calculates the point at which a line will intersect the y-axis using the available x-values and y-values.
· An array contains text, logical values, or empty cells that are ignored; but, the cells with the value zero are included.
· INTERCEPT shows the error value, when Y and X have a dissimilar number of data points.
Formulas:-
· The equation to calculate the intercept of the regression line, a, is:
where b is the slope, and is calculated as:
and where x and y are the sample means AVERAGE(Y) and AVERAGE(X).
INTERCEPT
Lets see an example,
INTERCEPT(Y, X)
B C
10 13
8 11
15 18
6 12
12 10
=INTERCEPT(B2:B6,C2:C6) is 1.2268
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10 | 13 | 1.226804 | |
| Row2 | 8 | 11 | ||
| Row3 | 15 | 18 | ||
| Row4 | 6 | 12 | ||
| Row5 | 12 | 10 | ||
| Row6 |
