Comment on page

COVAR_SAMP

This section contains reference documentation for the COVAR_SAMP function.

Returns the sample covariance between of 2 numerical columns.
COVAR_SAMP(col1, col2) = COVAR_POP(col1, col2) * besselCorrection
Signatures
COVAR_SAMP(col1, col2) -> double
Usage Examples
These examples are based on the Batch Quick Start.
SELECT COVAR_SAMP(numberOfGames, AtBatting) AS covariance 
FROM baseballStats
covariance
8270.973200974102

covariance
8270.973200974102

COVAR_POP

day

Last modified 1yr ago