Returns the standard error of the predicted y-value for each x in the regression.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
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})תוצאה: 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.