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 nonnumeric. 
  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.y={6,8,10,13,15,5}

x={1,4,9,11,20,3}

STEYX(G1:G6,H1:H6)=1.4350701130 2.y={2,9,1,8,17} x={10,4,11,2,6} STEYX(A1:A5,B1:B5)=5.944184833375 3.y={1,2,4,5,8} x={10,4,7,5} STEYX(A1:A5,B1:B4)=NAN

See Also

• INTERCEPT
• LINEST
• PEARSON