LinRegIntercepArray2 (Function)

image\trumpet2.gif Disclaimer

Uses regression analysis to determine the point at which a line will intersect the y-axis based on the of the calculation of a linear regression line from the values in two arrays (one with independent values and the other with dependent values).

  All array-based function calculations begin with array element 1.

Function

LinRegIntercepArray2(IndepArray, DepArray, ArraySz)

Parameters

Name

Type

Description

IndepArray

NumericArray

Specifies the numeric array of independent price points to evaluate.

DepArray

NumericArray

Specifies the numeric array of dependent price points to evaluate.

ArraySz

Numeric

Specifies the number of array elements to consider in the regression calculation

Returns

A numeric value containing the point at which a line will intersect the y-axis, based on the linear regression calculation.

See Also

LinRegArray2