What is STEYX?
Returns the standard error of the predicted y-value in a regression. Measures prediction accuracy.
Syntax
=STEYX(known_y's, known_x's)
Example
Formula: =STEYX(A1:A10, B1:B10)
Result: 1.23
How It Works
Estimates typical prediction error. Smaller values indicate more accurate predictions.