Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > STEYX
 

STEYX(known_y's, known_x's)

 
 Returns the standard error of the predicted y-value for each x in the regression. The standard error is a measure of the amount of error in the prediction of y for an individual x.

 known_y'sThe array or range of dependent data points.
 known_x'sThe array or range of dependent data points.

 REMARKS
 
  		• The arguments must be either numbers or names, arrays, or references that contain numbers.
     
  		• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
     
  		• If known_y's and known_x's are empty or have a different number of data points, then #N/A is returned.

     EXAMPLES
     
     A
    1=STEYX({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) = 3.306
    		 
     Functions - S | Index - S | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top