SteYX (Standard Error of Estimates)

Returns the standard error of estimates in linear regression with two variables (for example, Y = Intercept + Slope * X).

Syntax

SteYX([Y], [X])

Where:

Y is an array or range of dependent data points.

X is an array or range of independent data points.

Expression

Usage Notes

If an argument value contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

It is an invalid condition for Y and X to be empty or have a different number of data points.