Excel functions / Statistics
STEYX function
The standard error of the regression: the typical distance of a y value from the best-fit line.
Syntax
=STEYX(known_y, known_x)
Arguments
known_y: The dependent values: what you want to explain or predict.known_x: The independent values, one for each known_y.
When to use it
STEYX gives the standard error of the predicted y in a straight-line fit: how far, typically, the actual values sit from the line. Small means the line fits well.
Examples
How far points sit from their trend line
A B C D 1 x y 2 1 2 0.89 3 2 4 4 3 5 5 4 4 6 5 5 In D2:
=STEYX(B2:B6, A2:A6)→ 0.89
Common mistakes
- Argument order. The y values come first, as in SLOPE and INTERCEPT.
STEYX in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: STEYX
- Danish: STFYX
- Dutch: STAND.FOUT.YX
- Finnish: KESKIVIRHE
- French: ERREUR.TYPE.XY
- German: STFEHLERYX
- Hungarian: STHIBAYX
- Italian: ERR.STD.YX
- Norwegian: STANDARDFEIL
- Polish: REGBŁSTD
- Portuguese (Brazil): EPADYX
- Portuguese (Portugal): EPADYX
- Russian: СТОШYX
- Spanish: ERROR.TIPICO.XY
- Swedish: STDFELYX
- Turkish: STHYX
Related functions
- SLOPE: The slope of the straight line that best fits the data: how much y changes for each 1 added to x.
- INTERCEPT: Where the best-fit straight line crosses the y axis: the predicted y when x is 0.
- RSQ: R squared: the share of the variation in y that the best-fit line explains, from 0 to 1.
- LINEST: Fits a straight line by least squares and returns its slope(s) and intercept, with the full regression statistics (standard errors, R², F, sums of squares) if you ask. Spills.