Functions
STEYX
Standard error of regression
Try it
When to use it
When should I use STEYX?
Use STEYX to measure the standard error of the predicted y-values in a linear regression, giving you a sense of how accurately the regression line estimates individual data points.
Used in
Syntax
STEYX(known_y,known_x)Examples
=STEYX({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) // => 3.3057189502100415