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.
known_y’s (required). The dependent set of observations or data
known_x’s (required). The independent set of observations or data
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 ...