# Documentation/Calc Functions/INTERCEPT

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

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:

## ODF standard:

## Equivalent Excel functions:

INTERCEPT