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.