VSTEYX function

Description

VSTEYX(variableX,variableY[,filter]) returns the standard error of the predicted y-values in the regression of variableY on variableX. An optional filter can be specified.

The equation for VSTEYX is:

$$ \sqrt{ \frac{1}{n-2} \left[ \sum_{}^{}{(y-\bar{y})^2} - \frac{ \left[ \sum_{}^{}{(x-\bar{x})(y-\bar{y})} \right]^2 } {\sum_{}^{}{(x-\bar{x})^2}} \right]} $$

Note that in comparison with the corresponding Excel 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

VINTERCEPT function
VSLOPE function
VCORREL function.
Statistical spreadsheet functions on variables