Returns the standard error of the predicted y-value for each x in the regression.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
STEYX(known_ys, known_xs)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})Kết quả: 1.1547
Calculates the standard error for the given set of y and x values.
A lower STEYX value indicates that the data points are closer to the regression line, suggesting a better fit.