Home › Functions › Statistical › STEYX
fx
STEYX
Statistical  ·  Since: Excel 2003  ·  9 languages

Returns the standard error of the predicted y-value for each x in the regression. The standard error is a measure of the amount of error in the prediction of y for an individual x.

🌐 Translations

English STEYX
Deutsch STFEHLERYX
Français ERREUR.TYPE.XY
Español ERROR.TIPICO.XY
Italiano ERR.STD.YX
Português EPADYX
Nederlands STAND.FOUT.YX
Polski REGBŁSTD
Русский СТОШYX

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

STEYX(known_y's,known_x's)

Arguments

known_y's (required) — An array or range of dependent data points.
known_x's (required) — An array or range of independent data points.

▶ Examples

=STEYX(A3:A9,B3:B9)

Related functions

Copied to clipboard