6: Clarius Model 4200A-SCS Parameter Analyzer
6-262 4200A-901-01 Rev. C / February 2017
REGFITXINT Formulator function
Performs a linear regression fit.
Usage
REGFITXINT(VX, VY, STARTPOS, ENDPOS)
The name of any column (vector) listed under Columns
The name of any column (vector) listed under Columns
For the range of X and Y values to be fitted, the row number (index) of the starting
For the range of X and Y values to be fitted, the row number (index) of the ending
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 = REGFITYINT + REGFITSLP * X
where REGFITSLP and REGFITYINT are slope and Y-intercept constants.
• Returns the value of the X intercept for relationship above.
(–REGFITYINT/REGFITSLP).
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
EARLYV = REGFITXINT(COLLECTORV, COLLECTORI, 25, LASTPOS(COLLECTORV))
Also see
REGFIT (on page 6-260)
REGFITYINT (on page 6-263)
To Next Page
Loading...
Need help?
General
