# INTERCEPT

**Definition/Description of Formula:**

Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).

**Syntax:**

`INTERCEPT(dependent, independent)`

`dependent`

- The range representing the array or matrix of dependent data.- independent - The range representing the array or matrix of independent data.

**Notes **

- Any text encountered in the
`value`

arguments will be ignored.

**See Also:**

: Calculates the standard error of the predicted y-value for each x in the regression of a dataset.`STEYX`

: Calculates the slope of the line resulting from linear regression of a dataset.`SLOPE`

: Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.`RSQ`

: Calculates r, the Pearson product-moment correlation coefficient of a dataset.`PEARSON`

: Calculates the expected y-value for a specified x based on a linear regression of a dataset.`FORECAST`

: Calculates r, the Pearson product-moment correlation coefficient of a dataset.`CORREL`

### To use the INTERCEPT Formula, simply begin with your edited Excellentable:

### Then begin typing the INTERCEPT formula in the area you would like to display the outcome: