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.
· 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).
Lets see an example,
=INTERCEPT(B2:B6,C2:C6) is 1.2268