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

PreviousCOUNTMVNextCOVAR_SAMP