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: