LinearTrendSlopeValue
Returns the value of trend line slope after regressing the X and Y values in the function.
- Returned Output: Numeric
- Library: PQL \ Dynamic \ Grid
- Version: 2020.02.000
- Compatibility: Any content (regardless of data source) in the relevant parts of the application
Syntax
LinearTrendSlopeValue( <Numeric List> , <Numeric List> )
* Click on the function's arguments above for more details on the input values.
Comments
- The first numeric list is a listing of values representing the "X" values in the regression logic.
- The second numeric list is a listing of values representing the "Y" values in the regression logic.
- The formula returns the value of "m" in the standard linear regression model of "y=mx +b "
Examples
The example below uses the following example grid.
This example returns an "m" coefficient of 3151.8 assuming that the sales figures are the "y" values and the margin figures are the "x" values.
LinearTrendSlopeValue(dataSetColumn(1), dataSetColumn(0))