|
STEYX |
  
|
|
STEYX |
|
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