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

INTERCEPT(known_y's, known_x's)

 
 Returns the intersection with the y-axis using a linear regression plotted through known values.

 known_y'sThe dependent set of observations or data.
 known_x'sThe independent set of observations or data.

 REMARKS
 
  		• Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the intercept when you want to determine the value of the dependent variable when the independent variable is 0 (zero). For example, you can use the INTERCEPT function to predict a metal's electrical resistance at 0°C when your data points were taken at room temperature and higher.
     
  		• The arguments should 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" contain a different number of data points or contain no data points, then #N/A is returned.
     
  		• The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (828234).

     EXAMPLES
     
     A
    1=INTERCEPT({2,3,9,1,8},{6,5,11,7,5}) = 0.048
    2=INTERCEPT({2,4,6},{6,3,8}) = 2.211
    3=INTERCEPT({2,4,6},{6,3,8,2,3,7}) = #N/A
    4=INTERCEPT("some text",{6,3,8}) = #VALUE!
    		 
     Functions - I | Index - I | Office Online 

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