Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
6-250
4200A-901-01 Rev. C / February 2017
LINFIT Formulator function
Finds a linear equation and returns a new column (vector).
Usage
LINFIT(
VX
,
VY
,
STARTPOS
,
ENDPOS
)
VX
The name of any column (vector) listed under Columns
VY
The name of any column (vector) listed under Columns
STARTPOS
The row number (index) of the first set of
X
and
Y
values
ENDPOS
The row number (index) of the second set of
X
and
Y
values
Details
Finds a linear equation of the form
Y = a + bX
from two sets of
X
and
Y
values selected from two
columns (vectors),
VX
and
VY
. This equation corresponds to a line drawn through two points on a
curve that is created by plotting the values in
VY
against the values in
VX
. The two points are
specified by the arguments
STARTPOS
and
ENDPOS
.
Using the linear equation, returns a new column (vector) containing
Y
values calculated from all
X
values in column
VX
.
If a
VX
or
VY
value at either
STARTPOS
or
ENDPOS
is an invalid number (that is, the value is
#REF
),
the function will not return a valid result.
To return a linear regression fit for two columns (vectors), use the
REGFIT
function.
Example
RESISTORFIT = LINFIT (rESV, RESI, FIRSTPOS(rESV), LASTPOS(rESV))
Also see
