COVAR_POP

This section contains reference documentation for the COVAR_POP function.

Returns the population covariance between of 2 numerical columns.
COVAR_POP(col1, col2) = E[col1 * col2] - E[col1]E[col2]
Signatures
COVAR_POP(col1, col2) -> double
Usage Examples
These examples are based on the Batch Quick Start.
SELECT COVAR_POP(numberOfGames, hits) AS covariance 
FROM baseballStats
covariance
2314.249154477403

covariance
2314.249154477403

COUNTMV

COVAR_SAMP

Last modified 11mo ago