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

Syntax

Remarks

Examples

Description