Articles with the tag:
Articles with the tag:
Try in the cloud

STEYX Function

The STEYX function is one of the statistical functions. It is used to return the standard error of the predicted y-value for each x in the regression line.


STEYX(known_y's, known_x's)

The STEYX function has the following arguments:

Argument Description
known_y's An array of the dependent variables.
known_x's An array of the independent variables with the same number of elements as known_y's contains.


Empty cells, logical values, text, or error values supplied as part of an array are ignored. If they are supplied directly to the function, text representations of numbers and logical values are interpreted as numbers.

The known_y's and known_x's must contain the same number of data values otherwise the function will return the #N/A error value.

How to apply the STEYX function.


The figure below displays the result returned by the STEYX function.

STEYX Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action