** Syntax**. INTERCEPT(

** 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**

. The dependent set of observations or data*known_y’s*(required). The independent set of observations or data*known_x’s*(required)

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 ...

Start Free Trial

No credit card required