Excel INTERCEPT Function

Use:

Computes intercept of linear regression equation between two variables

Syntax:

INTERCEPT( y-range , x-range )

Example:

Cell E8 formula:     INTERCEPT( C2:C9 , B2:B9 )

 

Notes:

The order of the X and Y data is extremely important. INTERCEPT( C2:C9 , B2:B9 ) is not the same as INTERCEPT( B2:B9 , C2:C9 ).

Related Functions:

SLOPE, COVAR, CORREL, RSQ