-SCS Parameter Analyzer Reference Manual Section 6:
4200A-901-01 Rev. C / February 2017 6-253
LINFITYINT Formulator function
Finds a linear equation and returns the Y intercept.
Usage
LINFITYINT(VX, VY, STARTPOS, ENDPOS)
The name of any column (vector) listed under Columns
The name of any column (vector) listed under Columns
The row number (index) of the first set of X and Y values
The row number (index) of the second set of X and Y values
Details
Finds a linear equation and returns the Y intercept as follows:
• 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.
• Returns the Y intercept of the linear equation (value of a in Y = a + bX).
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 the Y intercept of a linear regression fit for two columns (vectors), use the REGFITYINT
function.
Example
OFFSET = LINFITYINT(GATEV, GATEI, FIRSTPOS(GATEV), LASTPOS(GATEV))
Also see
REGFITYINT (on page 6-263)
To Next Page
Loading...
Need help?
General
