# Documentation/Calc Functions/STEYX

STEYX

## Category:

Statistical Analysis

## Summary:

Fits a straight line to supplied data using linear regression and returns the standard error of actual y-values compared to y-values on the straight line found.

## Syntax:

STEYX(DataY; DataX)

## Returns:

Returns a real number which is the standard error of the predicted y values in DataY for each x in DataX in the regression.

## Arguments:

DataY is a name, array, or reference to a range of cells containing the Y data which are real values representing the y-components of points in a data set.

DataX is a name, array, or reference to a range of cells containing the X data which are real values representing the x-components of points in a data set.

• If a cell contains text or empty cells, then the function ignores these values. For logical values, TRUE is considered as 1 and FALSE as 0.
• If a cell contains 0 then the function includes it.
• If the dimensions of DataX and DataY are not same then the function returns an error value.

• The formula for STEYX is:

Here x̄ and ӯ are mean values for DataX and DataY, respectively, and n is the count of the total number of (xi,yi) pairs.

• For more details on standard error, visit Wikipedia.

## Examples:

DataY DataX
1 195 200
2 151 180
3 148 178
4 189 165
5 183 192
6 154 144
Formula Description Returns
=STEYX(A1:A6;B1:B6) Calculates the standard error in a regression for the data passed as references to ranges of cells. 20.9991200254713
=STEYX({8,9,10,11};{50,80,110,140}) Calculates the standard error in a regression for the data passed as arrays. 0

STEYX