Excel STEYX Function
The STEYX function returns the standard error of the predicted y value for each x in a linear regression given by a series of coordinates represented by paired numbers.
The STEYX function returns a numeric value.
- Arguments can be either of the following:
- Names, arrays, or references that contain numbers.
- Logical values and other values that can be converted to numbers that you type directly into the list of arguments will be counted.
- If text or empty cells are referenced as either of the arguments, the values will be ignored.
- STEYX returns the #N/A error if known_ys and known_xs have different numbers of data points.
- STEYX returns the #DIV/0! error if known_ys and known_xs are empty or have less than three data points.
- The equation for the standard error of the predicted y value is:
Where x and y are the sample means of the two arrays of values, and n is the sample size.
Take the table below as an example. To get the standard error of the predicted y-value for each x in the regression, please copy or enter the formula below in the result cell, and press Enter to get the result.