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

SLOPE(known_y's [,known_x's])

 
 Returns the slope of the linear regression line through data points in known_y's and known_x's. The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line.

 known_y'sThe array or cell range of numeric dependent data points.
 known_x'sThe set of independent 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, SLOPE returns the #N/A error value.
     
  		• The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (828142).

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

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