STEYX() returns the aggregated standard error of the predicted y-value for each x-value in the regression for a series of coordinates represented by paired numbers in x-expression and y-expression iterated over a number of records as defined by a group by clause.
Return data type: numeric
|y_value||The expression or field containing the range of y-values to be measured.|
|x_value||The expression or field containing the range of x-values to be measured.|
Text values, NULL values and missing values in any or both pieces of a data-pair result in the entire data-pair being disregarded.
Examples and results:
Add the example script to your app and run it. Then add, at least, the fields listed in the results column to a sheet in your app to see the result.
Load *, 1 as Grp;
LOAD * inline [
] (delimiter is '|');
STEYX(KnownY, KnownX) as MySTEYX
Resident Trend Group By Grp;
In a table with the dimension MySTEYX, the result of the STEYX() calculation in the data load script is 2.0714764.