Returns the standard error of the predicted y-value for each x in the regression.
Cú pháp
STEYX(known_ys, known_xs)Đối số
known_ysbắt buộc
An array or range of dependent data points.
known_xsbắt buộc
An array or range of independent data points.
The STEYX function calculates the standard error of the predicted y-value for each x in a regression. This value measures the amount of error in the prediction of y for an individual x.
=STEYX({3, 4, 9}, {1, 2, 3})→1.1547Calculates the standard error for the given set of y and x values.
Prepare data
Organize your dependent (y) and independent (x) data into two separate columns or arrays.
Apply function
Enter the STEYX function referencing your data ranges to calculate the standard error.
A lower STEYX value indicates that the data points are closer to the regression line, suggesting a better fit.