Learn How to Use Microsoft Excel INTERCEPT Function

Microsoft Excel INTERCEPT Function

The main purpose of the Microsoft Excel INTERCEPT function is to get the intercept of a linear regression line. That implies, with the help of the INTERCEPT function you can able to return the point at which a regression line will intersect the y-axis based on known x and y values. So, with the help of the INTERCEPT function, you can able to get the intercept of the linear regression line.

Return Value of INTERCEPT Function

The return value will be the y-axis intercept value.

Syntax of INTERCEPT Function

=INTERCEPT(known-ys, known-xs)

Where the arguments:

• known-ys: This is the array or range of numeric data points which are dependent values.
• known-xs: This is the array or range of numeric data points, which are independent values (optional).

How to Use Microsoft Excel INTERCEPT Function?

So we know that Microsoft Excel INTERCEPT function you can able to get the intercept of a linear regression line. That implies, with the help of the INTERCEPT function you can able to return the point at which a regression line will intersect the y-axis based on known x and y values. So, with the help of the INTERCEPT function, you can able to get the intercept of the linear regression line.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel