Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
6-260
4200A-901-01 Rev. C / February 2017
REGFIT Formulator function
Performs a linear regression fit.
Usage
REGFIT(
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
For the range of
X
and
Y
values to be fitted, the row number (index) of the starting
values
ENDPOS
For the range of
X
and
Y
values to be fitted, the row number (index) of the ending
values
Details
Performs a linear regression fit as follows:
•
Fits the following relationship, of the form
Y = a + bX
, to a specified range of values in two
columns (vectors) (column
VX
containing
X
values and column
VY
containing
Y
values):
Y = REGF REGFITSLP * X
where
REGFITSLP
and
REGFITYINT
are slope and Y-intercept constants.
•
Using the above linear relationship, 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.
Example
COLLECTORFIT = REGFIT(COLLECTORV, COLLECTORI, 25, LASTPOS(COLLECTORV))
Also see
(on page 6-261)
(on page 6-263)
