Spread Formula Reference
INTERCEPT
Formula Functions > Functions H to L > INTERCEPT

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:

INTERCEPT Equation

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

Version Available

This function is available in product version 1.0 or later.

See Also

FORECAST | Statistical Functions