Documentation/Calc Functions/STEYX

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.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/SLOPE SLOPE]

[[Special:MyLanguage/Documentation/Calc_Functions/INTERCEPT INTERCEPT]

[[Special:MyLanguage/Documentation/Calc_Functions/LINEST LINEST]

ODF standard:
Section 6.18.76, part 2

Equivalent Excel functions:
STEYX