## 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)`

#### 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.

**Error.**

User does not have sufficient privileges to access this Content

Learn More