Formulas and functions > Functions from A to Z > STEYX (standard error of a linear regression)

Syntax:

STEYX(y_values, x_values)

Description:

This returns the standard error of a linear regression.

The standard error is a measure of the reliability of a linear regression: the greater the standard error, the more the estimated values deviate from the actual values.

For the arguments y_values and x_values, you usually specify a cell range.

Y_values are the dependent variables.

X_values are the independent variables.

Note:

Note that this function expects the y_values first and then the x_values – not the other way around.

Note:

The linear regression is performed with this function using the least squares method.

Example:

The resistance of a temperature-sensitive resistor has been measured at several temperatures.

Cells A1:A4 contain the temperatures that were measured: 8, 20, 25, 28

Cells B1:B4 contain the resistances measured: 261, 508, 608, 680

The following calculation returns the standard error of the resistances predicted by linear regression:

STEYX(B1:B4, A1:A4) returns 4.97351