WorksheetFunction.Intercept (Excel)

Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values.

The arguments should be either numbers or names, arrays, or references that contain numbers. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included. If known_y's and known_x's contain a different number of data points or contain no data points, Intercept returns the #N/A error value. The equation for the intercept of the regression line, a, is:

Intercept (Arg1, Arg2)

Dim dblIntercept As Double
dblIntercept = WorksheetFunction.Intercept(Arg1:=, Arg2:=)

Arguments

Arg1 - Known_y's - the dependent set of observations or data

Arg2 - Known_x's - the independent set of observations or data