Buzz
In this article, we introduce you to the STEYX function, one of the widely used statistical functions in Excel.
Description: The function computes the standard error of predicted y values for each x value in regression.
Syntax: STEYX(known_y's, known_x's)
In this context:
- known_y's: Array or range of dependent data points, a required parameter.
- known_x's: Array or range of independent data points, a required parameter.
Note:
- The argument can be a number, a name, or an array reference containing numbers.
- When directly typing logical values and presenting text-formatted numbers as arguments of the function -> these values are still calculated, but a cell with a value of 0 is still considered.
- The function produces an error when the arguments are text or values that cannot be converted.
- If known_y's and known_x's have different data point counts -> the function returns an error value #N/A.
+ x represents the sample mean AVERAGE(number1, number2, …).
+ n denotes the sample size.
Example:
Calculate the standard error of the predicted y values for each x value in the regression of values in the data table below:
In the cell where you want to calculate, input the formula: =STEYX(C6:C12, D6:D12)
Press Enter -> the standard error of the predicted y values for each x value in regression is:
When the number of data points in known y’s and known x’s differs -> the function returns an error value #N/A.
If the number of data points in known y’s and known x’s is less than 3 -> the function returns an error value #DIV/0.
Here are instructions and specific examples when using the STEYX function in Excel.
Wishing you all the best in your endeavors!
