# Documentation/Calc Functions/INTERCEPT

INTERCEPT

## Category:

Statistical Analysis

## Summary:

Calculates the point at which a regression line will intersect the y-axis by using known x-values and y-values.

## Syntax:

INTERCEPT(DataY; DataX)

## Returns:

Returns a real number.

## Arguments:

DataY is an array of real numbers or a name or reference to a range of cells containing them which are the dependent set of observations or data.

DataX is an array of real numbers or a name or reference to a range of cells containing them which are the independent set of observations or data.

• If a name/array/reference to a cell contains text or empty cells, then the function ignores these values. Whenever a value in either X or Y is ignored the other (either Y or X, respectively) will also be ignored.
• If a cell contains 0, TRUE or FALSE then the function includes it.
• If the dimensions of DataX and DataY are not same then the function returns an error value.

• INTERCEPT calculates the α parameter of the regression line

y = α + βx

• The equation for INTERCEPT is :

α = ӯ - βx̄

where β is given as:

Here x̄ and ӯ are mean values for DataX and DataY, respectively.

• For more details on simple linear regression, visit Wikipedia.

## Examples:

DataY DataX
1 195 200
2 151 180
3 148 178
4 189 165
5 183 192
6 154 144
Formula Description Returns
=INTERCEPT(A1:A6;B1:B6) Calculates the α parameter value expected for a linear trend based on the data. 82.3470308193435
=INTERCEPT({8,9,10,11};{50,80,110,140}) Calculates the α parameter value expected for a linear trend based on the data passed as array. 6.33333333333333

SLOPE

LINEST

## ODF standard:

Section 6.18.38, part 2

INTERCEPT