Definition

Calculates the standard error of the predicted y-value for each x in the regression of a dataset.

Sample Usage

STEYX(A2:A100,B2:B100)

Syntax

STEYX(data_y, data_x)

  • data_y - The range representing the array or matrix of dependent data.

  • data_x - The range representing the array or matrix of independent data.

Notes

  • Any text encountered in the value arguments will be ignored.

See Also

SLOPE: Calculates the slope of the line resulting from linear regression of a dataset.

RSQ: Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.

PEARSON: Calculates r, the Pearson product-moment correlation coefficient of a dataset.

INTERCEPT: Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).

FORECAST: Calculates the expected y-value for a specified x based on a linear regression of a dataset.

COVAR: Calculates the covariance of a dataset.

CORREL: Calculates r, the Pearson product-moment correlation coefficient of a dataset.

To use the STEYX Formula, simply begin with your edited Excellentable:

 

Then type in the STEYX Formula in the area you would like to display the outcome:

 

By adding the value you would like to calculate the STEYX formula for, Excellentable will generate the outcome:

 

Error.

User does not have sufficient privileges to access this Content
Learn More