STEYX function
STEYX(YValues,
XValues) STEYX(YValues;
XValues)
YValues
{ Number }
The vertical coordinates of the data points. This array must have the same size as the other array parameter.
XValues
{ Number }
The horizonal coordinates of the data points. This array must have the same size as the other array parameter.
Returns
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.
Example
STEYX({ 8, 9, 10,
11 }, { 50, 80, 110, 140 })STEYX({ 8; 9; 10; 11 }; { 50;
80; 110; 140 })
Returns 0.