Documentation/Calc Functions/INTERCEPT

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:
y = &alpha; + &beta;x
 * INTERCEPT calculates the &alpha; parameter of the regression line


 * The equation for INTERCEPT is :

&alpha; = ӯ - &beta;x̄

where &beta; is given as:

Here x̄ and ӯ are mean values for DataX and DataY, respectively.
 * For more details on simple linear regression, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/SLOPE SLOPE]

[[Special:MyLanguage/Documentation/Calc_Functions/LINEST LINEST]

ODF standard:
Section 6.18.38, part 2

Equivalent Excel functions:
INTERCEPT