Returns the standard error of the predicted y-value for each x in the regression.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
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})Ergebnis: 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.