regression-slope
Returns the slope of the regression line. This is computed as follows: COVAR_POP(numeric_expression1,numeric_expression2) / VAR_POP(numeric_expression2)
Note: Supported only in dynamic query mode.
Syntax
regression-slope ( numeric_expression1 , numeric_expression2 )
regression-slope ( numeric_expression1 , numeric_expression2 for
[ all|any ] expression { , expression } )
regression-slope ( numeric_expression1 , numeric_expression2 for
report )Example
regression-slope ( Cost , Margin )Result
The slope of the regression line for Cost and Margin.
Result data
| Cost | Margin | regression-slope (Cost, Margin for report) |
|---|---|---|
| 4 | 0.33 | 30.43609023 |
| 5 | 0.28 | 30.43609023 |
| 9.22 | 0.23 | 30.43609023 |
| 15.93 | 0.28 | 30.43609023 |
| 34.97 | 0.3 | 30.43609023 |