INTERCEPT

Formulas / INTERCEPT
Calculate the intercept of a regression line.
INTERCEPT(known_y's,known_x's)
  • known_x - required, independent set of data
  • known_y - required, dependent set of data

Examples

  • =INTERCEPT({2;0},{-1;1})

    The function is used to calculate the point of intersection between two linear functions. For example, the function returns 1 because the first argument is {2;0} which is the line 2x+0 and the second argument is {-1;1} which is the line -1x+1. The result is 1, which is the point of intersection between the two linear functions.

  • =INTERCEPT({2;3},{-1;2})

    The function can be used to calculate the slope of a line. For example, the function returns -1. This is because the first argument is {2;3} which is the line 2x+3 and the second argument is {-1;2} which is the line -1x+2. The result is -1, which is the slope of the line.

  • =INTERCEPT({3;-2},{1;3})

    The function can also be used to calculate the y-intercept of a line. For example, the function returns -2. This is because the first argument is {3;-2} which is the line 3x-2 and the second argument is {1;3} which is the line 1x+3. The result is -2, which is the y-intercept of the line.

Summary

The INTERCEPT function allows users to calculate the intercept point of a line by providing existing x-values and y-values. It is a simple and convenient way to calculate this point without having to manually calculate it.

  • The INTERCEPT function calculates the intercept of a regression line, using an array or range of known_ys and known_xs values as arguments.
  • The INTERCEPT function can be used to calculate the value of a dependent variable when the independent variable is zero.


Frequently Asked Questions

What is the INTERCEPT function?
The INTERCEPT function is available in Excel 2007 and later versions. It returns the intercept for a linear regression. The INTERCEPT function is improved in later versions of Excel.
How do I use the INTERCEPT function?
To use the INTERCEPT function, enter the known x-values in one column, the known y-values in a second column, and the INTERCEPT function in the third column. The function will return the intercept of the linear regression based on the data.
What versions of Excel support the INTERCEPT function?
The INTERCEPT function is available in Excel 2007 and later versions.
What are the benefits of using the INTERCEPT function?
  • It quickly returns the intercept of a linear regression.
  • The function is improved in later versions of Excel.
  • It is simple to use.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV