covar_samp
This function is used to return the sample covariance between two columns of numerical values.
Syntax
covar_samp(col1, col2)
Parameters
Parameter |
Mandatory |
Description |
---|---|---|
col1 |
Yes |
Columns with a data type of numeric. If the values are of any other type, NULL is returned. |
col2 |
Yes |
Columns with a data type of numeric. If the values are of any other type, NULL is returned. |
Return Values
The return value is of the DOUBLE type.
Example Code
- Calculates the sample covariance between the inventory (items) and the price of all offerings. An example command is as follows:
select covar_samp(items,price) from warehouse;
The command output is as follows:
_c0 1.242355
- When used with group by, it groups all offerings by warehouse (warehourseId) and returns the sample covariance between the inventory (items) and the price of offerings within each group. An example command is as follows:
select warehourseId, covar_samp(items,price) from warehourse group by warehourseId;
The command output is as follows:
warehouseId _c1 city1 1.03124 city2 1.03344 city3 1.33425
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot