Microsoft® Excel® 2010 Formulas & Functions Inside Out

INTERCEPT()

Syntax. INTERCEPT(known_y’s,known_x’s)

Definition. This function returns the intersection of the regression line (see Figure 12-124, in the discussion of the SLOPE() function).

The function calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on the best-fit regression line drawn through the known x-values and known y-values.

Arguments

• known_y’s (required). The dependent set of observations or data

• known_x’s (required). The independent set of observations or data

Note

Arguments can be numbers, names, arrays, or references containing numbers. If an array or a reference argument contains text, logical values, or empty cells, those values are ignored. Note that cells ...