VINTERCEPT function

Description

VINTERCEPT(variableX,variableY[,filter]) returns the intercept of the regression line of the independent variable variableX and the dependent variable variableY. An optional filter can be specified.

The equation for VINTERCEPT a is:

$$ a = \bar{y} - b \bar{x} $$

where b, the slope, is calculated as:

$$ b = \frac{ \sum_{}^{}{(x-\bar{x})(y-\bar{y})}} {\sum_{}^{}{(x-\bar{x})^2}} $$

Note that in comparison with the corresponding Excel INTERCEPT function, the order of the X and Y arguments is reversed.

Note

This function calculates a statistic on a variable. Be careful when you use this function in cells of the columns that correspond to the variable, because this actually adds a value to the variable which can lead to unexpected and faulty results. You can exclude the cell to avoid this.

Related functions

VSLOPE function
VCORREL function.
Statistical spreadsheet functions on variables