covar_pop.md

description
This section contains reference documentation for the COVAR_POP function.

COVAR_POP

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