ID EN
…
#Statistical

INTERCEPT

Excel Functions

Get intercept of linear regression line

Syntax

EXCEL 
=INTERCEPT(known_ys, known_xs)

Arguments

Parameter Description
known_ys An array or range of numeric data points (dependent values).
known_xs An array or range of numeric data points (independent values).

Return Value

y-axis intercept value

Details

The INTERCEPT function returns the point at which a line will intersect the y-axis based on known x and y values. The intercept point is based on a regression line plotted with known x and y values. A regression line is a line that best fits that known data points. Use the INTERCEPT function to calculate the value of a dependent variable when the independent variable is zero (0). The INTERCEPT function takes two arguments, known_ys and known_xs, which should be a range or array of numeric values. The known_ys represent dependent values and known_xs represent independent values. Both arguments must contain the same number values, or INTERCEPT will return #N/A. Values can be entered directly in INTERCEPT as array constants: Typically, values are supplied as ranges. In the example shown, the

Examples

Example

Values can be entered directly in INTERCEPT as array constants:

EXCEL 
=INTERCEPT({2;0},{-1;1}) // returns 1
Example

Typically, values are supplied as ranges. In the example shown, the formula in E5 is:

EXCEL 
=INTERCEPT(C5:C9,B5:B9) // returns 2
Equation

In the example shown, the intercept formula can be manually created like this:

EXCEL 
=AVERAGE(C5:C9)-SLOPE(C5:C9,B5:B9)*AVERAGE(B5:B9)

See Also

SLOPE LINEST