Changes

67 bytes added ,  10:49, 30 January 2014
no edit summary
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==
writer
5,435

edits