Section 6: Clarius Model 4200A-SCS Parameter Analyzer Reference Manual6-262 4200A-901-01 Rev. C / February 2017REGFITXINT Formulator functionPerforms a linear regression fit.UsageREGFITXINT(VX, VY, STARTPOS, ENDPOS)VX The name of any column (vector) listed under ColumnsVY The name of any column (vector) listed under ColumnsSTARTPOS For the range of X and Y values to be fitted, the row number (index) of the startingvaluesENDPOS For the range of X and Y values to be fitted, the row number (index) of the endingvaluesDetailsPerforms a linear regression fit as follows:• Fits the following relationship, of the form Y = a + bX, to a specified range of values in twocolumns (vectors) (column VX containing X values and column VY containing Y values):Y = REGFITYINT + REGFITSLP * Xwhere 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.ExampleEARLYV = REGFITXINT(COLLECTORV, COLLECTORI, 25, LASTPOS(COLLECTORV))Also seeREGFIT (on page 6-260)REGFITYINT (on page 6-263)
