INTERCEPT(dependent, independent) returns the intercept of the linear regression line : INTERCEPT « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. INTERCEPT
Input the formula: =INTERCEPT(B2:B6, C2:C6). Press Enter to get the result.
Input the formula: =INTERCEPT(B2:B6, C2:C6)
21.37.INTERCEPT
21.37.1.INTERCEPT(dependent, independent) returns the intercept of the linear regression lineINTERCEPT(dependent, independent) returns the intercept of the linear regression line