Navigation:  Formula Reference > Spreadsheet Formula Functions >

INTERCEPT

Previous pageReturn to chapter overviewNext page

 

This function returns the coordinates of a point at which a line intersects the y-axis, by using existing x values and y values.

Syntax

INTERCEPT(dependent,independent)

Arguments

This function has these arguments:

Argument

Description

dependent

An array of known dependent values (y’s)

independent

An array of known independent values (x’s)

You can use numbers, arrays, or references for the arguments.

Remarks

The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the intercept when you want to determine the value of the dependent variable when the independent variable is 0 (zero). For example, you can use this function to predict a metal’s electrical resistance at 0°C when your data points were taken at room temperature and higher.

If an array or reference argument contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero.

The number of dependent data points must be equal to the number of independent data points.

The equation for this function is:

where Y is the array of dependent variables, X is the array of independent variables, and n is the size of the arrays.

Data Types

Accepts arrays of numeric data for both arguments. Returns numeric data.

Examples

INTERCEPT(G1:G9,F1:F9)

INTERCEPT(R1C7:R9C7,R1C6:R9C6)

INTERCEPT({53000,57000,58000,69000,74500,55620,80000, 68700},{35,31,47,51,37,31,58,39}) gives the result 37060.4809987149

 

See Also

FORECAST