Changes

*It is calculates the  standard error for the straight line of best fit through a supplied set of <math> x </math> and <math> y </math> values.  

*It is calculates the  standard error for the straight line of best fit through a supplied set of <math> x </math> and <math> y </math> values.  

*The standard error for this line provides a measure of the error in the prediction of <math> y </math> for an individual <math> x </math>.  

*The standard error for this line provides a measure of the error in the prediction of <math> y </math> for an individual <math> x </math>.  

*The equation for the standard error of the predicted <math> y </math> is: SQRT(1/(n-2)[summation (y-y(bar)^2-[summation (x-x(bar)(y-y(bar)]^2/summation(x-x(bar))^2]  ,where x(bar) and y(bar) are the sample mean <math> x </math> and <math> y </math>.

*The equation for the standard error of the predicted <math> y </math> is:  

<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 x(bar) and y(bar) 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), 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.