Spread Formula Reference
Formula Functions / Functions H to L / INTERCEPT
In This Topic
    INTERCEPT
    In This Topic

    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