A-SCS Parameter Analyzer Reference Manual Section 6:
4200A-901-01 Rev. C / February 2017 6-251
LINFITSLP Formulator function
Finds a linear equation and returns the slope.
Usage
LINFITSLP(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
and
values
The row number (index) of the second set of
and
values
Details
Finds a linear equation and returns the slope 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 slope of the linear equation (value of b 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 slope of a linear regression fit for two columns (vectors), use the REGFITSLP function.
Example
RESISTANCE = 1/LINFITSLP(rESV, RESI, FIRSTPOS(rESV), LASTPOS(rESV))
Also see
REGFITSLP (on page 6-261)
To Next Page
Loading...
Need help?
General
