This function returns the coordinates of a point at which a line intersects the y-axis, by using existing x values and y values.
INTERCEPT(dependent,independent)
This function has these arguments:
| Argument | Description |
|---|---|
| dependent | An array of known dependent values (y’s) |
| independent | An array of known independent values (x’s) |
You can use numbers, arrays, or references for the arguments.
The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the intercept when you want to determine the value of the dependent variable when the independent variable is 0 (zero). For example, you can use this function to predict a metal’s electrical resistance at 0°C when your data points were taken at room temperature and higher.
If an array or reference argument contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero.
The number of dependent data points must be equal to the number of independent data points.
The equation for this function is:
where Y is the array of dependent variables, X is the array of independent variables, and n is the size of the arrays.
Accepts arrays of numeric data for both arguments. Returns numeric data.
INTERCEPT(G1:G9,F1:F9)
INTERCEPT(R1C7:R9C7,R1C6:R9C6)
INTERCEPT({53000,57000,58000,69000,74500,55620,80000, 68700},{35,31,47,51,37,31,58,39}) gives the result 37060.4809987149
This function is available in product version 1.0 or later.
FORECAST | Statistical Functions
