Documentation/Calc Functions/STEYX

From The Document Foundation Wiki
Jump to navigation Jump to search


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:
Steyx updated.png

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:

SLOPE

INTERCEPT

LINEST

ODF standard:

Section 6.18.76, part 2

Equivalent Excel functions:

STEYX