STEYX

Formulas / STEYX
Calculate the standard error of the predicted y-value for each x in a regression.
STEYX(known_y's, known_x's)
  • known_y's - an array or cell range
  • known_x's - an array or cell range

Examples

  • =STEYX(A3:A9,B3:B9)

    The STEYX function can be used to return the standard error of the predicted y-value for each x in the regression. This is useful for determining the accuracy of the regression line. The syntax for this function is above, where A3:A9 and B3:B9 are the x values and y values, respectively. This function can be used to determine the standard error of the predicted y-value for each x in the regression.

  • =STEYX(A3:A9,B3:B9)

    The STEYX function can be used to calculate the standard error of the predicted y-value for each column in the regression. This is useful for determining the accuracy of the regression line. The syntax for this function is above, where A3:A9 and B3:B9 are the x values and y values, respectively. This function can be used to determine the standard error of the predicted y-value for each column in the regression.

Summary

The STEYX function calculates the standard error of the predicted y-value for each x in the regression. It requires known_y's and known_x's arguments which can be numbers, arrays, or references and must only contain numbers.

  • The STEYX function returns the standard error of the predicted y-value for each x in the regression model.
  • It takes two arguments which can be numbers, arrays, or references, but must contain only numbers.
  • The function ignores empty cells, text, and logical values from arrays or references.


Frequently Asked Questions

What is the STEYX function?
The STEYX function is a Sourcetable calculation used to determine the standard error of the predicted y-value for each x in a regression.
What is the standard error?
The standard error is a measure of the amount of error in the prediction of y for an individual x.
What arguments does the STEYX function require?
The STEYX function requires two arguments: known_y's and known_x's. These arguments can be numbers, arrays, or references.
What values does the STEYX function ignore?
The STEYX function ignores logical values, text representations of numbers, and empty cells.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV