arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

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]

hashtag
Signatures

COVAR_POP(col1, col2) -> double

hashtag
Usage Examples

These examples are based on the .

covariance
SELECT COVAR_POP(numberOfGames, hits) AS covariance 
FROM baseballStats

2314.249154477403

Batch Quick Start