Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Statistical Functions
INTERCEPT(dependent, independent) returns the intercept of the linear regression line
Input the formula: =INTERCEPT(B2:B6, C2:C6). Press Enter to get the result.