Difference between revisions of "Manuals/calci/STEYX"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
*<math>y</math> is set of dependent values. | *<math>y</math> is set of dependent values. | ||
*<math>x </math> is the set of independent values. | *<math>x </math> is the set of independent values. | ||
| − | |||
==Description== | ==Description== | ||
| Line 11: | Line 10: | ||
<math>\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 ]}</math> | <math>\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 ]}</math> | ||
where <math>\bar{x}</math> and <math>\bar{y}</math> are the sample mean <math> x </math> and <math> y </math>. | where <math>\bar{x}</math> and <math>\bar{y}</math> are the sample mean <math> x </math> and <math> y </math>. | ||
| − | *In <math> STEYX(y,x), y </math> is the array of the numeric dependent values and <math> x </math> is the array of the independent values. | + | *In <math> STEYX(y,x)</math>, <math>y </math> is the array of the numeric dependent values and <math> x </math> is the array of the independent values. |
*The arguments can be be either numbers or names, array,constants or references that contain numbers. | *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. | *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 | *This function will return the result as error when | ||
| − | 1. Any one of the argument is | + | 1. Any one of the argument is non-numeric. |
| − | 2. x and y are empty or that have less than three data points. | + | 2. <math>x</math> and <math>y </math> are empty or that have less than three data points. |
| − | 3. x and y have a different number of data points. | + | 3. <math>x</math> and <math>y </math> have a different number of data points. |
==Examples== | ==Examples== | ||
Revision as of 04:49, 30 January 2014
STEYX(y,x)
- is set of dependent values.
- is the set of independent values.
is set of dependent values.
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 and values.
- The standard error for this line provides a measure of the error in the prediction of for an individual .
- The equation for the standard error of the predicted is:
where and are the sample mean and .
![{\displaystyle {\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]}}}](https://wikimedia.org/api/rest_v1/media/math/render/png/f71cd618f3c8c4c1d1e43f8434dc9778e8b8a697)
where 
and 
are the sample mean - In , is the array of the numeric dependent values and 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. and are empty or that have less than three data points. 3. and 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