INTERCEPT

Syntax:

INTERCEPT ( known-ys , known-xs )

Description: Computes 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 a best-fit regression line plotted through the known x-values and known y-values.

Mathematical Formula:

The equation for the intercept of the regression line, a, is:

where the slope, b, is calculated as:

and where x and y are the sample means AVERAGE(known-xs) and AVERAGE(known-ys).

Arguments:

Name

Type

Description

known-ys

number, name, array, reference to number

The dependent set of observations or data. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

known-xs

number, name, array, reference to number

The independent set of observations or data. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

Return Type and Value: number – The point at which a line will intersect the y-axis by using existing x-values and y-values.

However, if

  • known-ys and known-xs contain a different number of data points, the return value is unspecified.

  • known-ys or known-xs contain no data points, the return value is unspecified.

example: