Menu
EXCEL INTERCEPT FUNCTION
Excel INTERCEPT Function Introduction
The Excel Intercept function calculates the intercept (the value at the intersection of the x- and y) of the a linear regression line to use a set of x and y values given by the user.
Description of Excel INTERCEPT Function
Syntax :
=INTERCEPT( known_y’s, known_x’s )
Parameters :
The following parameters are :
- Known y’s – The known y-values array.
- Known x’s – An array containing known x-values. It is important to note that the length of the known x’s array should be the same as the length of the known y’s array, and the variance of the known x’s must not be zero.
Step By Step Guide of F.DIST Function
Example :
The spreadsheet below illustrates how to use the Excel Intercept function to find the point where the linear regression line through the known x’s and known y’s (listed in cells F2:F7 and G2:G7) crosses the y-axis. =INTERCEPT is the formula for the Intercept function ( G2:G7, F2:F7 )
Key Points
- #N/A – Occurs if the given arrays of known x and known y are of different lengths.
- #DIV/0! – Occurs if either the variance of the given known x’s is zero or one of the supplied known x’s or known y’s arrays is empty.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
