STEYX (YValues, XValues) STEYX (YValues; XValues)
YValues
The vertical coordinates of the data points. This array must have the same size as the other array parameter.
XValues
The horizonal coordinates of the data points. This array must have the same size as the other array parameter.
Returns
Number Number
The standard error of actual vertical coordinates compared to the vertical coordinates of a straight line which has been fit to the given data using linear regression.
Fits a straight line to data using linear regression and returns the standard error of the actual vertical coordinates compared to the vertical coordinates of the straight line. A small result means that the data points lie close to the line.
Examples
STEYX ({ 2, 4, 5, 8 }, { 1, 2, 3, 4 })
STEYX ({ 2; 4; 5; 8 }; { 1; 2; 3; 4 })
Returns roughly 0.59.
STEYX ({ 8, 9, 10, 11 }, { 50, 80, 110, 140 })
STEYX ({ 8; 9; 10; 11 }; { 50; 80; 110; 140 })
Returns 0, as all data points lie on a straight line.