Excel - Microsoft Excel Intercept Function

Description

The Excel Intercept function calculates the intercept (the value at the intersection of the y axis) of the linear regression line through a supplied set of x- and y- values. 

The syntax of the function is : 

INTERCEPT( known_y's, known_x's ) 

Where the arguments are as follows : 

Intercept Function Example

The spreadsheet below shows an example of the Excel Intercept function used to calculate the point at which the linear regression line through the known_x's and known_y's (listed in cells F2:F7 and G2:G7) intersects the y-axis. These known_x's and known_y's are plotted on a chart in the spreadsheet. 

The above example gives the result 2.4. 

Intercept Function Errors

The most common errors from the Excel Intercept function are listed in the table below : 

Common Errors