STEYX Function Explained
The STEYX Function in Microsoft Excel is used to calculate the standard error of the predicted y-value for each x in the regression. It takes two arguments: the known_y’s and the known_x’s. It returns the standard error of the predicted y-value for each x in the regression.
STEYX Function Syntax
STEYX(known_y's, known_x's)
- known_y’s – The set of y-values (dependent variable) in the data set.
- known_x’s – The set of x-values (independent variable) in the data set.