Documentation/Calc Functions/INTERCEPT

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

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.

Additional details:

  • INTERCEPT calculates the α parameter of the regression line

y = α + βx

  • The equation for INTERCEPT is :

α = ӯ - βx̄

where β is given as:

Forecast n.png

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

Related LibreOffice functions:

SLOPE

LINEST

ODF standard:

Section 6.18.38, part 2

Equivalent Excel functions:

INTERCEPT