-
Microsoft Excel Office 365
Learn How to Use Microsoft Excel INTERCEPT Function
In this article, you will learn how to use the Microsoft Excel INTERCEPT function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel INTERCEPT function return value and syntax with the help of some examples.
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
Comments