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 (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 |
Related LibreOffice functions:
ODF standard:
Equivalent Excel functions:
STEYX