Skip to main content

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:

 

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

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

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

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

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

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

 


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: 

 

A
B
1
Y
X
2
4
1
3
5
1.7
4
10
2.3
5
23
5
6
7
8
Result
-1.891067538

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.