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.
Syntax
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. |
Notes
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.
Examples
The figure below displays the result returned by the STEYX function.
Host ONLYOFFICE Docs on your own server or use it in the cloud
Article with the tag:
Browse all tags