Returns the standard error of the predicted y-value for each x in the regression.
الصيغة
STEYX(known_ys, known_xs)المعاملات
known_ysمطلوب
An array or range of dependent data points.
known_xsمطلوب
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.