SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / STEYX
In This Topic
    STEYX
    In This Topic

    This function returns the standard error of the predicted y value for each x. The standard error is a measure of the amount of error in the prediction of y for a value of x.

    Syntax

    STEYX(array_dep,array_ind)

    Arguments

    This function has these arguments:

    Argument Description
    array_dep Array of dependent values (y’s)
    array_ind Array of independent values (x’s)

    The arrays must be the same size.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    STEYX(A1:A17,B1:B17)

    STEYX({22,33,49,21,32,37,43},{31,28,29,42,35,37,34]) gives the result 10.14406

    See Also