ReferenceFunctionsStatistics Functions
STEYX
STEYX: Returns the standard error of y-estimates from a simple linear regression.
Summary
STEYX measures the typical residual size around the fitted regression line.
Remarks
- Requires paired x/y inputs with matching numeric lengths.
- Requires at least three paired points.
- Returns
#DIV/0!whenn < 3or x-values have zero variance. - Pairing and shape mismatches return spreadsheet errors from paired-array validation.
Examples
Perfect linear fit has zero standard error
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0
Non-zero regression standard error
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.408248290463863
Related functions
Runtime metadata
Category
Statistics
Signature
STEYX(arg1, arg2, ... argN: Number (Range))This function accepts a repeating argument pattern (min args: 2).
Arity
min 2, max 1
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PUREREDUCTIONNUMERIC_ONLY
Source