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

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

  1. How far points sit from their trend line

    ABCD
    1xy
    2120.89
    324
    435
    544
    655

    In D2: =STEYX(B2:B6, A2:A6) → 0.89

    Try this example

Common mistakes

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.

Translate a whole formula

Try STEYX in the playground

Related functions