Manuals/calci/STEYX

STEYX(y,x)

• $y$ is set of dependent values.
• $x$ is the set of independent values.

Description

• This function gives the standard error of the regression, which also is known as the standard error of the estimate.
• It is calculates the standard error for the straight line of best fit through a supplied set of $x$ and $y$ values.
• The standard error for this line provides a measure of the error in the prediction of $y$ for an individual $x$.
• The equation for the standard error of the predicted $y$ is:

${\sqrt {{\frac {1}{(n-2)}}\left[\sum (y-{\bar {y}})^{2}-{\frac {[\sum (x-{\bar {x}})(y-{\bar {y}})]^{2}}{\sum (x-{\bar {x}})^{2}}}\right]}}$ where ${\bar {x}}$ and ${\bar {y}}$ are the sample mean $x$ and $y$.

• In $STEYX(y,x)$, $y$ is the array of the numeric dependent values and $x$ is the array of the independent values.
• The arguments can be be either numbers or names, array,constants or references that contain numbers.
• Suppose the array contains text,logical values or empty cells, like that values are not considered.
• This function will return the result as error when

  1. Any one of the argument is non-numeric. 
  2. $x$ and $y$ are empty or that have less than three data points.
  3. $x$ and $y$ have a different number of data points.

Examples

1.

Spreadsheet

	A	B	C	D	E	F
1	6	8	10	13	15	5
2	1	4	8	11	20	3

=STEYX(A1:F1,A2:F2) = 1.4350701130

2.

Spreadsheet

	A	B	C	D	E
1	2	9	1	8	17
2	10	4	11	2	6

=STEYX(A1:E1,A2:E2)) = 5.944184833375

3.

Spreadsheet

	A	B	C	D	E
1	1	2	4	5	8
2	10	4	7	5

=STEYX(A1:A5,B1:B4) = NAN

Related Videos

Standard Error Of Estimate

See Also

• INTERCEPT
• LINEST
• PEARSON

References

• Standard Error