| 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 nonnumeric. | + | 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== |