|
<< Click to Display Table of Contents >> 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.
Additional info:
The linear regression is performed with this function using the least squares method.
Example:
The resistance of a temperature-dependent resistor has been measured at several temperatures.
Cells A1:A4 contain the temperatures that were measured (the independent variables): 8, 20, 25, 28
Cells B1:B4 contain the resistances that were measured (the dependent variables): 261, 508, 608, 680
The following calculation returns the standard error predicted by linear regression based on these values:
STEYX(B1:B4, A1:A4) returns 4.97351
See also: