INTERCEPT function

Category: Statistical
Introduced: Excel 2003

Summary

Returns the intercept of the linear regression line

Syntax

INTERCEPT(known_y's, known_x's) The INTERCEPT function syntax has the following arguments:
• Known_y's Required. The dependent set of observations or data.
• Known_x's Required. The independent set of observations or data.

Example

=INTERCEPT(A2:A6, B2:B6)

Microsoft Support Page

https://support.microsoft.com/en-us/office/intercept-function-2a9b74e2-9d47-4772-b663-3bca70bf63ef

Back to Functions