STEYX

Standard error estimation for a linear regression.

Syntax:

STEYX( y‑data:Range or Array, x‑data:Range or Array )

Returns the standard error of the linear regression line given by the y‑data and x‑data arrays.

Note:

STEYX() is implemented using a two-pass approach, first independently computing the mean values, then computing intermediate values (such as the sum of the squares, products) using the difference between each value and the corresponding mean value. This approach helps avoid many round-off errors and is also employed by Microsoft Excel 2003 and later.

Revisions:

This function was added in Fireworkz 2.00.