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.