Skip to Content

INTERCEPT

Returns the intercept of the linear regression line through data points

Syntax

INTERCEPT(known_y's, known_x's)

Parameters

  • known_y's: Required. The dependent set of observations or data
  • known_x's: Required. The independent set of observations or data

Example

=INTERCEPT(A1:A10, B1:B10)
Returns: NumberSince: Excel 2003