The Excel STEYX function calculates the standard error for the line of best fit, through a supplied set of x- and y- values.
Syntax: STEYX( known_y’s, known_x’s )
Where the function arguments are:
|known_y’s||–||An array of known y-values (the dependent variables)|
|known_x’s||–||An array of known x-values (the independent variables)|
The known_y’s and known_x’s arrays must contain the same number of data values. Note that the Steyx function will interpret text representations of numbers as numeric values. Other text values, that cannot be interpreted as numbers are ignored, along with the corresponding value in the other array of x- or y- values.
Steyx Function Example
Cells A2 – A10 and B2 – B10 of the spreadsheet below list a number of known x and known y values, and also shows these points, plotted on a chart, along with the line of best fit through the points. The Standard Error for the line of best fit can be calculated by the Excel Steyx function. This, function, which is shown in cell C12 of the example spreadsheet, has the form:
=STEYX( B2:B10, A2:A10 )
This returns the value 1.201186347 as the calculated standard error.
Steyx Function Errors
If you get an error from the Excel Steyx function this is likely to be one of the following:
|#N/A||–||Occurs if the array of known_x’s is not the same length as the array of known_y’s|
|#DIV/0!||–||Occurs if the supplied known_x’s and known_y’s arrays contain fewer than 3 values each|