# Documentation/Calc Functions/STEYX

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

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.

## Additional details:

- 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 (x_{i},y_{i}) 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 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

STEYX